Why todays date shows up as #### in excel doc.

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

Guest

I am trying to change the date in a cell that I am working on in an excel
worksheet. While typing, the date shows as it should 14 Mar 07; however,
after "entering" the numerals change to ######. What is going on here? We
are using the latest XP version.
 
you need to expand the column - the symbols just indicate that there isnt
enough space.
 
You must log in or register to reply here.

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

Excel High lightng dates in future, today and past 1
EXPIRED or DATE 3
Default Date Format in Excel 3
Regional Settings with Date 3
Excel How to get the number of days an item was opened from the today's date. 14
date comparison 2
Date shows as a number 1
Wrong Date when pasting/linking workbooks 2

Back
Top