Software

Ask something
Discussion Locked

problem with .csv conversion

0 helpful
5 replies

by lynne

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to convert an Access97 table to .csv format, however when I do this, leading zeros (in social security numbers) are removed. How can I maintain these leading zeros?

5 replies

by gregory pleau

Try changing the Social Security field to be a text field and export it as text instead of a number.

by adeal

I would format the column with the "custom" category, and put in "000000000" or "000-00-0000" if you want hyphens in the "type" field. This should work. I encountered the same problem when I was adding asset tag numbers to an audit sheet.

by lynne

I tried this, too, but the conversion to csv causes it to loose the format.

This discussion is closed to new replies.