This article has moved to a new location :
« Adding a new Layout in Magento 126.96.36.199
Integrating the Magento LiveChat Extention »
Excellent, works! Hard to fin stuff with Excel 2007
This worked very nicely. Thanks!
Wonderful, thanks. I had been filling in blank cells using a vba procedure that was very slow checking each cell. Your method should be much faster.
You are Welcome Stuart,
Yes this method is a lot faster than the VBA method, Glad its of help to you
Thanks for this tip! I figured there had to be an easy way to do this, even though the Excel Help doesn’t address it at all. There seem to be a lot of advice on going the other direction (blank to zero) but I needed to format a sparse spreadsheet for upload to a site that requires explicit zeroes, so this saved me a lot of work.
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.
Get every new post delivered to your Inbox.