Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with date formatting
Bascially i have been using a spreadsheet that i have set-up in as a template
to convert data for me. Part of the process see's me pasting an external spreadsheet into my template my problem is that all of a sudden this posted data has no format. The date is showing as the 1900 format i.e. the 1st of Jan 1900 shows as 1. No matter what i try i can't get the format to change. If i highlight a cell i can see the format in the formula bar but it doesn't show it on the sheet. Does anyone know how i can sort this out? or has the sheet become corrupted? Any help will be gratefully received |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with date formatting
That's the defoult for Excel.....if you want the 1904 system do Tools
Options CalculationTab check the 1904 box Vaya con Dios, Chuck, CABGx3 "Hawksby" wrote: Bascially i have been using a spreadsheet that i have set-up in as a template to convert data for me. Part of the process see's me pasting an external spreadsheet into my template my problem is that all of a sudden this posted data has no format. The date is showing as the 1900 format i.e. the 1st of Jan 1900 shows as 1. No matter what i try i can't get the format to change. If i highlight a cell i can see the format in the formula bar but it doesn't show it on the sheet. Does anyone know how i can sort this out? or has the sheet become corrupted? Any help will be gratefully received |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with date formatting
Maybe you're looking at formulas.
Tools|Options|View tab|uncheck formulas Hawksby wrote: Bascially i have been using a spreadsheet that i have set-up in as a template to convert data for me. Part of the process see's me pasting an external spreadsheet into my template my problem is that all of a sudden this posted data has no format. The date is showing as the 1900 format i.e. the 1st of Jan 1900 shows as 1. No matter what i try i can't get the format to change. If i highlight a cell i can see the format in the formula bar but it doesn't show it on the sheet. Does anyone know how i can sort this out? or has the sheet become corrupted? Any help will be gratefully received -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
Date Formatting in a Macro | Excel Discussion (Misc queries) | |||
Date formatting in Pivot Chart | Charts and Charting in Excel | |||
Date format problems when used in different countries | Excel Discussion (Misc queries) | |||
Date Format Problems?? | Excel Discussion (Misc queries) |