Forum Discussion

tea4u's avatar
tea4u
Copper Contributor
Jan 03, 2019

CSV format dropping leading zeros in a "general format" column

Happy New Year all!

I have been trying everything I can online with no luck, and am turning to you all for help.

 

Background…one of my work tasks is balancing and entering the details for our company credit card. It requires taking some downloaded detail (from a website) in a CSV formatted Excel spreadsheet, doing some additional formatting, saving it as a CSV spreadsheet and uploading it to Deltek (our accounting platform). Not a big to-do.

 

For 3 years this worked perfectly.

 

About a year ago something changed (I think in Excel) to where in one of my columns, which has been manually formatted (by me, the user) to a “General” format and has a leading zero (example the date 09242018) when I save the file (regardless of the type), the 0 (zero) drops and then Deltek doesn’t allow for the upload.

 

I have had our IT guys look into it with zero success. I have read umpteen articles online and followed everyone’s suggestion(s) with zero success.

 

I’m going to ask you…(see where this is going??) if you might have any idea(s), hints, clues, or any magic spell you might know to keep the leading zero from dropping (and yes, I have tried everything I found on the web).

 

I’m attaching a pre-formatted CSV spreadsheet, the step by step instructions for formatting it (remember it needs to remain a CSV format) and one that I formatted with the leading zeros dropped (columns B & D).

 

I would love any input you might have.

 

Thank you all in advance. 

Resources