Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
You need to use a ' to stop excel removing the leading 0's
Excel wont display the ' in the Cell but will leave the leading 0's alone
Let me know how you go please.
can you attach the sheet to this question please do I can see the format
Use the Attach File button
yes, checking it now
ok, as a CSV you cannot stop this for these numbers as it always treats it as a number.
Is there any reason it cannot be an XLSX format which stops this?
No, others will not be able to do this, not in CSV, its one of the limits of CSV, but the XLSX file is exactly the same for all programs except it keeps the formatting.
But this is a documented issue with CSV, and in a way it makes sense as it has no format control in CSV
It needs to be kept in the Excel format (xlsx)
If you would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.
Yes, as I indicated in my last message to you, it needs to be an XLS or XLXS file, then the apostrophe will work for you.
And please take a second to rate my service by clicking one of the stars at the top of the screen then submit