LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Leading Zero in .csv format

I've read all the post and blogs on csv files dropping leading zero's
and still haven't found a solution. I have Excel 2002 and when I save
file as .csv it drops the leading zero. I've tried formatting cells as
text before saving as csv, importing data with cells set as text,
under custom format my version of evcel doesn't have an option for
00000 or #0000. I was told that I need to upgrade to a newer version
of excel. Any help would be greatly appriciated..
 
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
Format to show leading zero lehigh46 Excel Worksheet Functions 5 February 25th 09 01:20 PM
Format for Leading Zeros DavidW[_7_] Excel Programming 5 April 19th 06 09:01 PM
How do I save a leading 0 in a csv format? Kathy Excel Worksheet Functions 2 February 16th 06 07:56 PM
number format with leading 0 Darby Excel Discussion (Misc queries) 3 November 22nd 05 03:37 PM
Format a cell to keep leading zeros. Shadyhosta New Users to Excel 5 July 27th 05 04:37 PM


All times are GMT +1. The time now is 10:52 PM.

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

About Us

"It's about Microsoft Excel"