A cell with ##### generally indicates the column is not wide enough to
display the value stored: make the column wider by pulling the bar between
the column headers (to make column B wider, pull the bar between B and C) 0r
use Format Column and change the width. A negative date value can also cause
cell to show ###
If you want to see 0123 and not 123: type a single quote (') then the digits
OR format the cell with Custom Format 0000.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Teri" wrote in message
...
What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.