Date changes in data

M

myasmana

I have a spreadsheet that has a date column which is required. The
spreadsheet is then uploaded for a conversion into another software product
we use. This date column is only for the year. When we enter the date such as
2010 and format the column as custom, yyyy, it will change the date to 1905.
We have tried changing the format to text, general, all with the same
outcome. Any suggestions?

Thanks,
Barb
 
G

Gord Dibben

2010 is not a date.

Excel treats it as the serial number for the date of July 02, 1905 which is
2009 days after 1/1/1900

Why not just leave 2010 as is with no formatting?


Gord Dibben MS Excel MVP
 

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

Remove date format? 3
Date Formats 1
Date looks funny! 3
date format 1
Excel 2007 text import as text not date 3
Date format changes in mail merge using Excel worksheet as data 2
Date Format 3
Columns formatted As Dates Are Exported as a Number to Text 1

Top