Excel and large numbers

[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?

[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

[Anne_Phillips]

Thanks very much that was very helpful