Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ques
 
Posts: n/a
Default save text field w/ leading zeros in .csv format & not lose zeros?

I currently have a csv file with a field that has one digit numbers. I need
to create a text field and convert the one digit number to two digit text by
adding a leading zero. I have tried using the concatenate function to add
the leading zero, but when I close the csv file, it reverts back to one
digit. How can I get the file to save the field as text and include the
leading zero?
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

Check your CSV file in Notepad, not in Excel. Excel will frequently convert
your text representation of a number into a number, even though it likely was
written out to disk with the leading zero

"Ques" wrote:

I currently have a csv file with a field that has one digit numbers. I need
to create a text field and convert the one digit number to two digit text by
adding a leading zero. I have tried using the concatenate function to add
the leading zero, but when I close the csv file, it reverts back to one
digit. How can I get the file to save the field as text and include the
leading zero?

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
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 6 April 2nd 23 08:33 PM
leading zeros in text format BigBrook Excel Discussion (Misc queries) 5 December 11th 08 09:00 PM
Format a cell to keep leading zeros. Shadyhosta New Users to Excel 5 July 27th 05 04:37 PM
zero supress leading zeros when chg format from text to number HeatherO Excel Worksheet Functions 4 February 28th 05 12:11 AM
Adding Leading Zeros to Text Jenn Excel Discussion (Misc queries) 4 January 12th 05 07:51 PM


All times are GMT +1. The time now is 09:28 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"