monicamarie
Board Regular
- Joined
- Sep 2, 2008
- Messages
- 72
- Office Version
- 365
I have to export data from an apllication into a CSV file. One of the fields of data contains 16 digit card numbers. Unfortunately, the application does not give me any options as to how I want the data converted such as text, general, etc. When the export is completed, the end result is that the column with the 16 digit card numbers are all in scientific format and all end in a zero. Is there anyway to fix this after the fact? Or is the last digit lost once the export is done?
I would like to find a way to change the numbers back to text (or any other format that allows the cells to display all 16 digits as well as keep the last original digit).
Is this possible? Thank you for any help you can give me.
I would like to find a way to change the numbers back to text (or any other format that allows the cells to display all 16 digits as well as keep the last original digit).
Is this possible? Thank you for any help you can give me.