Adding zero's to blank cells

[Anthony G]

Hello to all!! Is it possible to selcect all of the blank cells in a given range (multiple columns/rows) and insert a 0?

Any advice will be greatly appreciated.

Thanks!!!

Anthony

[Mark W.]

Yes, select your range, choose the Edit | Go To... | Special... Blanks menu command, type 0, and press Control+Enter.

[Anthony G]

Hey Mark, thanks for the response!!!. When I select the range, it appears that it will only allow a zero to be placed on a line that has a formula and not in any other cells. When I select a few blank cells and follow the steps that you outlined, it tells me that no blank cells were found. Any other suggestions??? Thanks again!!!

Anthony

[Anthony G]

I actually just found out something very interesting. The data that I'm trying to do this with was copied to Excel from an Access table. The cells appear to be blank, which had me wondering as to why Mark's method wasn't working. I then went into those cells and selected "clear contents". It now works............BUT WHY???

Any thoughts?

Thanks

Anthony

[Mark W.]

On 2002-03-12 05:27, Anthony G wrote:
I actually just found out something very interesting. The data that I'm trying to do this with was copied to Excel from an Access table. The cells appear to be blank, which had me wondering as to why Mark's method wasn't working. I then went into those cells and selected "clear contents". It now works............BUT WHY???

Any thoughts?

Thanks

Anthony

I suspect that your data contained either spaces (" ") or the null text string (""). These are quite different from an empty cell. One way to eliminate these values is to select them and use the Data | Text to Columns... menu command.

[ This Message was edited by: Mark W. on 2002-03-12 06:28 ]