entering a date into cell and get ## symbols
 

i am entering a date value into a cell and i that it shows is "##" Even when
i print it shown "##" and no date why?

entering a date into cell and get ## symbols
 

Make the cell wider

--
Regards,

Peo Sjoblom

Portland, Oregon




"Steve" wrote in message
...
i am entering a date value into a cell and i that it shows is "##" Even
when
i print it shown "##" and no date why?

entering a date into cell and get ## symbols
 

Steve wrote:
i am entering a date value into a cell and i that it shows is "##" Even when
i print it shown "##" and no date why?

Normally the # character shows up when the column is not wide enough to
display a date or number. Try widening the column to see if you can see
the date, you might need to choose a different date format that takes up
less space.

George