Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get excel to stop rounding numbers | Excel Discussion (Misc queries) | |||
Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |