Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Preserve Leading Zeros when saving XL file to CSV
- Thread starter Fiat77
- Start date
SkipVought
Programmer
Fiat77,
You must store the numeric values as STRINGS instead of numbers, fixed length with leading zeros.
for instance....
[tt]
=TEXT(A1, "0000000")
[/tt]
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
You must store the numeric values as STRINGS instead of numbers, fixed length with leading zeros.
for instance....
[tt]
=TEXT(A1, "0000000")
[/tt]
Skip,
[sub]
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]Only ONE fig per cookie!
[/sub]- Status
Similar threads
- Locked
- Question
