| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date columns are formatted incorrectly on export to excel
Hello, I have date columns (HYYMMDs) when i export to excel from my grid,
excel formats the date columns and the display is different from the exported data. How can i stop excel from formatting the columns ? Any inputs greatly appreciated Thanks, Mona |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date columns are formatted incorrectly on export to excel
How is the cell formatted in Excel, what do you get in the export, and what do
you want exported? What is HYYMMDs in a date column? When we know exactly what you want, it's a lot easier to provide the advice you are looking for. One way you can force Excel to maintain formats is to convert your data to text, as in: =Text(a1,"yymmdd") -- Regards, Fred "Mona" wrote in message ... Hello, I have date columns (HYYMMDs) when i export to excel from my grid, excel formats the date columns and the display is different from the exported data. How can i stop excel from formatting the columns ? Any inputs greatly appreciated Thanks, Mona |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Text Box be Formatted in Columns? | Excel Discussion (Misc queries) | |||
| Deleted Columns replaced with formatted columns | Excel Discussion (Misc queries) | |||
| date in Excel displays incorrectly when merged in letter | Excel Discussion (Misc queries) | |||
| Excel shouldn't bitch about a "date format" when formatted as txt | Excel Discussion (Misc queries) | |||
| how to get the number of days between two date formatted fields in vba for excel? | Excel Worksheet Functions | |||
Hybrid Mode
