Exporting to Word in a csv file

B

Brad

I am doing the above and leading zeros are being dropped...I need them in
because they are account codes that I am uploading to my GL. Can anyone help?

Brad
 
M

Marc

I've run into leading zero problems before when exporting/importing.

Try this--make sure your data items with leading zeros are "text" format,
that should preserve the leading zeros.

I made a test file, saved it as CSV, then pulled into Word (insert file),
and the leading zeros were still there.

But, if you open up the CSV file again in Excel, the leading zeros
disappear...
 
B

Brad

Thanks Marc, worked great

Brad

Marc said:
I've run into leading zero problems before when exporting/importing.

Try this--make sure your data items with leading zeros are "text" format,
that should preserve the leading zeros.

I made a test file, saved it as CSV, then pulled into Word (insert file),
and the leading zeros were still there.

But, if you open up the CSV file again in Excel, the leading zeros
disappear...
Click to expand...
 
E

Earl Kiosterud

Marc,

The export from Excel as csv will include the leading zeroes, if they're
there in the sheet. Opening the csv file in Notepad can be used to verify
that. When the csv is opened in Excel, it treats the fields as numbers, the
same as if you'd manually typed them in. Numbers don't have leading zeroes
(though they can be formatted to show them). So they're lost in the
reopened file because they were converted to numbers.
 
D

David McRitchie

Oops, just noticed that you are importing into Word not into Excel,
but you could copy and paste from Excel to Word and then the
formatting would to into Word.
 
Top