Hello Everyone.

I need to upload a csv file to another system however, when I save my excel spreadsheet as a csv file, it drops the leading zero. I have tried the following:

format cells as text
putting an apostrophe before each number

and none of the above worked.

Does anyone have any ideas? Unfortunately my file must be uploaded as csv.

Thanks!

It may be no different from what you're already experiencing, but, what about using the TEXT function to create the leading zeros?

Such as, for 6 character entries,
=TEXT(reference,"000000")

regards,
Fazza