Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 9th 08, 05:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 6
Default 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   Report Post  
Old January 9th 08, 05:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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   Report Post  
Old January 9th 08, 05:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get excel to stop rounding numbers Brian Excel Discussion (Misc queries) 3 April 8th 07 04:10 PM
Excel won't stop rounding numbers. Please help [email protected] Excel Discussion (Misc queries) 9 December 18th 06 08:38 PM
How do I stop excel from rounding numbers? c-swym Excel Discussion (Misc queries) 6 June 16th 06 02:04 AM
How do I stop numbers from rounding in Excel? Josette_N Excel Discussion (Misc queries) 10 January 27th 06 04:19 PM
How do I make Excel stop rounding off my numbers that are 16 digi. Aida Excel Discussion (Misc queries) 1 December 6th 04 05:34 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017