Page 1 of 1
Excel and large numbers
Posted: Tue Sep 18, 2007 10:52 am
by Anne_Phillips
We produce CSV files from our software which contain ISBN numbers which since this year are 13 digit numbers (they used to be 10 digit numbers). Clients are complaining that the ISBNs are appearing in scientific notation. I^ve discovered that Excel will display all numbers with 12+ digits in this format. You can format the column to Text in Excel and then it will appear correctly. Is there any way we can force the column to be text from R&R?
=> RE: Excel and large numbers
Posted: Thu Sep 20, 2007 10:21 am
by kfleming
You could create a calculated field and use the transform function to convert the number to a formatted string.____For example if the field ISBN13 has the numeric value 9780552155670____The calculated expression:__transform(isbn13,"999-9999999999")____will give you the following output when you open the exported CSV in ____978-0552155670____Hope this helps.____Kathleen__R&R Support
==> RE: Excel and large numbers
Posted: Mon Oct 01, 2007 1:13 pm
by Anne_Phillips
Thanks very much that was very helpful