entering a date into cell and get ## symbols

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Steve said:
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
 
Back
Top