dates appear as error hashes
 

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??

dates appear as error hashes
 

Hi

Try widening the columns. Does this resolve the problem?

Regards

Roger Govier


pembers wrote:
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??

dates appear as error hashes
 

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


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=487960