LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default long numbers colapse

What causes a long number - 555116311212 - to colapse into 5.55E+11? When I
try to widen the cell the number now reads 555116000000. I am using this
spreadsheet as .csv to import and this change in numbers causes duplications
in numbers and interferes with the import.
 
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
Getting a formula when typing long numbers SueK Excel Discussion (Misc queries) 7 January 22nd 09 01:05 AM
Ensure that all numbers are 8 digits long DianeG Excel Worksheet Functions 4 March 26th 08 01:18 PM
Importing long numbers from CSV file Harry Excel Discussion (Misc queries) 4 January 14th 07 02:02 AM
the end of long numbers turn to 0s how do i stop that? Shawna New Users to Excel 2 November 21st 05 07:19 PM
dealing with very long numbers 149047 Excel Discussion (Misc queries) 3 July 7th 05 01:45 PM


All times are GMT +1. The time now is 07:03 PM.

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

About Us

"It's about Microsoft Excel"