Quote:
Originally Posted by effCup
Yes, sorry. My bad. Excel stripped the leading zeros from the file as I was organising it. Do I need to re-do the text to preserve all the leading zeros? That would be a right pita because although I have the original text the leading-zero-stripping happened right at the beginning of the process, i.e. I'd have to re-do all the formatting, cleaning, etc. Yikes. I'll say no for now but... maybe later, maybe.
|
Try highlighting the relevant column in Excel and formatting it as plain text. Although Excel assumes it's a number when importing, it usually retains the whole string and just defaults to number format.
If that doesn't work, try editing one of the number fields adding ' at the front and see if it displays the leading zeros.
Regards
40+