I entered 11/22/2004 in excel workbook and it keeps changing to ##

F

Firefly

I was working on my mileage work sheet in excel for some reason when I
entered 11/22/04 it keeps changing to #######. What's this. If I click on
it the 11/22/2004 is shown, but when I go to another cell it changes back to
#######.
I don't know what I could do to show the date on ther worksheet as
11/22/2004/ Please help.
 

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

Sequencial page numbering of multiple tabs 0
Pasting a cell into bookmarked table from excel vba 1
Word doc keeps changing to ALL CAPS 0
Find then highlight in yellow 6
Embed the same Excel multiple times 0
Multiple table lookup 13
Excel Formula to add network file link to each month 1
Needs help combining functions. 3

Top