A
amb
I have a programmatic problem, where CSVs are being produced automatically
by some Transact SQL processes.
The CSVs are then used by a number of users, some who are not very
technically literate
The CSVs can look a bit like this
"0401","Data","Data","000234092"
But when the CSV is opened in excel the preceeding zeroes vanish. Im trying
to force it to open with the zeroes already there. Otherwise I am
continually have to show users through how to use the 'Format Cells' options
to get the numeric IDs to display correctly.
Is there any way I can do this.
I have tried preceeding the data with a single quote eg "'0401" but Excel
converted it into the display
(Incidentally CSVs are used because not all users are using Excel and for
the minority that arent, they can live with the 401's)
Amb
by some Transact SQL processes.
The CSVs are then used by a number of users, some who are not very
technically literate
The CSVs can look a bit like this
"0401","Data","Data","000234092"
But when the CSV is opened in excel the preceeding zeroes vanish. Im trying
to force it to open with the zeroes already there. Otherwise I am
continually have to show users through how to use the 'Format Cells' options
to get the numeric IDs to display correctly.
Is there any way I can do this.
I have tried preceeding the data with a single quote eg "'0401" but Excel
converted it into the display
(Incidentally CSVs are used because not all users are using Excel and for
the minority that arent, they can live with the 401's)
Amb