T
Tina Hudson
Good afternoon,
I'm exporting data from a view I created in Lotus Notes 8.0 to Excel 2007.
One of the fields looks like a number (it has no alpha characters), but is
set up as "general". The field is 11 characters long and can contain a "0"
(zero) as the first character in the field. I have no control over this
field.
When I export selected documents from the view and save it as a .csv file,
which we've been instructed to do, and open with Excel, the leading "0" drops
off.
The problem with this is, I only need the first 4 characters. Before Lotus
Notes 8.0, I could save as a Lotus file and had no problem with the "0" not
dropping off. I can not save as a Lotus File now - have to save as .csv
Is there a quick fix to preventing the "0" from dropping off?
I'm exporting data from a view I created in Lotus Notes 8.0 to Excel 2007.
One of the fields looks like a number (it has no alpha characters), but is
set up as "general". The field is 11 characters long and can contain a "0"
(zero) as the first character in the field. I have no control over this
field.
When I export selected documents from the view and save it as a .csv file,
which we've been instructed to do, and open with Excel, the leading "0" drops
off.
The problem with this is, I only need the first 4 characters. Before Lotus
Notes 8.0, I could save as a Lotus file and had no problem with the "0" not
dropping off. I can not save as a Lotus File now - have to save as .csv
Is there a quick fix to preventing the "0" from dropping off?