• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

amounts in csv file

C

CAAT

New Member
hello

i want to save a file into CSV but it removes leading zeros from the account number.
eg. 00123 (in .xlsx) convert to 123 (in .csv)
i want to keep the original format as 00123

please help
 
Did you check the file in Text Editor(Notepad / Textpad etc.) also? It could be just that the leading zeroes disappear when you are trying to view it in Excel.
 
You must log in or register to reply here.
Back
Top