entering a date into cell and get ## symbols

S

Steve

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

George

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?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting question: how to format duration (time spent)? 0
Autofill Date in Word 15.33 for Mac 0
Project Status Date 1
Cell data entering slow! 0
Project Start and End Date is not consistent 1
Auto Fill Word Documents 4
Get the right language when inserting a date 2
How do I post date a letter? 1

Top