| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes in data
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date changes in data
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 On Fri, 28 May 2010 07:49:02 -0700, myasmana wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the display data format cell already contain data as date | Excel Discussion (Misc queries) | |||
| Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
| Date data not viewed as Date? | Excel Discussion (Misc queries) | |||
| count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Hybrid Mode
