dates appear as error hashes

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

[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

[Roger Govier]

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