var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: csv file dropping leading zeros
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.
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,