M
Melinda
I have had the same problem in both Excel 1997 and Excel
2000. I always use the Accounting format which gives a
dash for a 0. However, every once in while I will get a 0
instead of a dash. When I do that I extend out the
decimals and way out there are some numbers. I always
check to make sure that any formulas I have either round
or are from whole numbers so there is no possibility of it
being a rounding problem. I think it's probably a glitch
in the Excel program, but I haven't talked with anyone
else who has encountered this. Mainly I think because
most people don't use the dash for 0 format. Any ideas?
2000. I always use the Accounting format which gives a
dash for a 0. However, every once in while I will get a 0
instead of a dash. When I do that I extend out the
decimals and way out there are some numbers. I always
check to make sure that any formulas I have either round
or are from whole numbers so there is no possibility of it
being a rounding problem. I think it's probably a glitch
in the Excel program, but I haven't talked with anyone
else who has encountered this. Mainly I think because
most people don't use the dash for 0 format. Any ideas?