Thread: ####
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default ####

One more suggestion for the #### could be negative date or time.

And another.

If you have between 255 and 1024 characters in the cell and are formatted to
Text, you will get the #####.

If that is the case, format to General.


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 07:14:01 -0800, Teri wrote:

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.