Yeah, that too<g
Gord
On Tue, 12 Apr 2005 16:31:05 -0500, Dave Peterson
wrote:
With the added benefit that blank cells won't turn to 0.
Gord Dibben wrote:
Peg
Slight ammendment to your post, if I may.
Copy a blank cell and paste specialadd is easier then typing a zero in the
cell then clearing it after the add.
Gord Dibben Excel MVP
On Tue, 12 Apr 2005 12:32:32 -0700, "PegL"
wrote:
If the data was entered as text, it will stay text even if you reformat the
cell. One way to correct this is to put a zero in a blank cell, copy it,
then select the cells you want to be numeric, click Paste special and click
on Add in the function section.
"scottr" wrote:
In excel, I tried to convert numbers to number format, using
format/cells/number from the category list. But it won't take, and stays
text-like. Any ideas?
|