Stop excel rounding my 16/17 digit numbers
I receive a report which has transaction numbers either 16/17 digits long.
Is there anyway I can retrieve the full number from excel? Much appreciated. |
Stop excel rounding my 16/17 digit numbers
Excel keeps track of 15 significant digits.
If you are receiving a workbook (.xls), then it's probably too late. If your report is plain text (.prn, .csv, .txt), then you could bring those fields into excel as text (not General) and see all the characters. If the file is named .csv, then rename it to .txt. Then use File|Open and you'll be able to specify each field the way you want in that text import wizard dialog. E Halliday wrote: I receive a report which has transaction numbers either 16/17 digits long. Is there anyway I can retrieve the full number from excel? Much appreciated. -- Dave Peterson |
Stop excel rounding my 16/17 digit numbers
You need to treat them as text when you import to Excel, otherwise
values which are thought (by Excel) to be numbers will be truncated to 15 digit precision. Hope this helps. Pete On Jan 9, 4:07*pm, E Halliday wrote: I receive a report which has transaction numbers either 16/17 digits long. * Is there anyway I can retrieve the full number from excel? Much appreciated. |
All times are GMT +1. The time now is 03:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com