Date columns are formatted incorrectly on export to excel

G

Guest

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
 
F

Fred Smith

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")
 

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

Converting date format 4
Date format getting muddled 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Columns formatted As Dates Are Exported as a Number to Text 1
Word to Excel: Export comments with text and line number 0
Match, VLookup... who knows? 3
SAP export to Excel 2003 1
how do I increase the number of columns in a report? 1

Top