Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 7th 05, 08:45 AM
GLS
 
Posts: n/a
Default Re-formatting of dates from Excel to CSV

When I save an Excel worksheet as a CSV file the dates are re-formatted from
04/11/2004 to 4/11/2004 (British style Date ddmmyyyy). This doesnt happen
immediately on saving but when the CSV file is closed and then reopened.

Any suggestions how I can prevent it dropping the leading zero?

Many thanks

GLS
--
GLS

  #2   Report Post  
Old February 7th 05, 09:03 AM
Oliver Ferns via OfficeKB.com
 
Posts: n/a
Default

In a word, No!! All I can suggest is you reformat the cells when the file
is opened. I tried preceeding the date with a ' and Excel got shot of the '
AND the leading 0. The only other suggestion I have is to save as a TXT
file and use the text import wizard to format the column as text, then the
leading 0 remains but Excel doesn't recognize them as dates until you * by
1. Bit of a pain innit?

Hth,
Oli

--
Message posted via http://www.officekb.com
  #3   Report Post  
Old February 7th 05, 12:42 PM
Earl Kiosterud
 
Posts: n/a
Default

GLS,

It's probably writing the data to the csv as it appears in the sheet. It's
the reopening with Excel that's using a different format. The next question
is: Is the csv for some other application? If so, you're good to go. To
see exactly what's in the csv, open it with NotePad, or any text editor.
There's more on text files and Excel at www.smokeylake.com/excel.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"GLS" wrote in message
...
When I save an Excel worksheet as a CSV file the dates are re-formatted
from
04/11/2004 to 4/11/2004 (British style Date ddmmyyyy). This doesnt happen
immediately on saving but when the CSV file is closed and then reopened.

Any suggestions how I can prevent it dropping the leading zero?

Many thanks

GLS
--
GLS





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting in Excel Help Please..... Willie T Excel Discussion (Misc queries) 4 February 9th 05 02:28 PM
Auto Formatting an Excel Spreadsheet Ray Excel Discussion (Misc queries) 0 January 19th 05 09:57 PM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 10:39 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017