Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mhe
 
Posts: n/a
Default problem when saving CSV file


Why the leading 0 (zero) is dropped when I save the excel
file as CSV file? Is there a way not the leading zero not
to be dropped. What should I do to keep the zero leading
on it.

Thanks a lot.
  #2   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"mhe" wrote in message
...

Why the leading 0 (zero) is dropped when I save the excel
file as CSV file? Is there a way not the leading zero not
to be dropped. What should I do to keep the zero leading
on it.

Thanks a lot.


What do you have in the cell where you want a leading 0 in the csv file? I
guess you could try to format the cells as text, that may help.

/Fredrik


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
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 0 March 19th 05 06:01 PM
opening file problem please help Steve Goodrich Excel Discussion (Misc queries) 2 March 1st 05 10:40 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 04:45 PM
import problem on huge xls file f_huba@toplita. Excel Worksheet Functions 2 November 5th 04 12:09 AM


All times are GMT +1. The time now is 01:58 AM.

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

About Us

"It's about Microsoft Excel"