Preserve large numbers in text format in CSV
Saving to CSV destroys large numbers intentionally stored as text to avoid the scientific notation curse.
I have an 18 digit number in a txt document. I import as comma delimited, forcing text format for the number's column. It displays all 18 digits as text. Good.
I save as .csv and reopen. The text formatting is gone and the number is now in scientific notation with a loss of precision (the last three numbers are 000). BAD!
I start over. I enter the formula ="="""&B2&"""". Upon creating the formula the data is presented as =”345234523454353456” literally.
After saving as csv and reopening, it loses one level of translation and is presented as 34523452345435 without the = and “”.
After closing and reopening again it loses that last level and reverts to scientific notation.
Solution: If you can present a currency format of $123.00 and still manipulate it as a number, you can convert ALL numbers, including over 15 digits as their text equivalent by default, right justified, and still manipulate them behind the scenes as numbers.
This business of losing precision when displaying large numbers and saving to .csv has to stop.
Real world reason: Sometimes real estate parcel numbers are 18 digits long. We need to actually use all 18 digits, ya? Converting them to scientific notation, and/or saving them to .csv to upload to a crm or mailing company, only to have the last three digits converted to 000 is problematic.