laziness, impatience, and hubris | |
PerlMonks |
Re: Retaining leading Zeros in csv fileby igelkott (Priest) |
on Jul 03, 2008 at 18:48 UTC ( [id://695437]=note: print w/replies, xml ) | Need Help?? |
Not a perfect solution but a leading single quote (') is enough to prevent excel's auto-conversion. The only catch is that when the data is read from a file, the quote will be visible until the cell is reevaluated (eg, cursor hitting return after the cursor is in the cell for editing). Might try a simple macro to touch each cell? The "call it a text file" approach seems better but this is an alternative if a text file is inconvenient.
In Section
Seekers of Perl Wisdom
|
|