dates appear as error hashes

P

pembers

When I type dates in cells on an Excel spreadsheet they become a series of
hashes. But other dates of the same format in other workbooks are fine. Why
does this error keep on occuring. I think may be the cells are not in the
right format for me to add dates. Can i change this??
 
R

Roger Govier

Hi

Try widening the columns. Does this resolve the problem?

Regards

Roger Govier
 
Y

y_not

The number hash usually means that the cell is not wide enough to
display the information.

Try resizing the columns - that should work.

Good luck

Tony
 
Top