| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto rounding of large numbers
Whenever I copy and paste a number from another application into a cell in
Excel and the number is larger than 15 digits (that appears to be the magic size), it seems to round the number up and pad to the right with zeros. Example, If I format the cell as numeric, and paste 6214008046176059 it appears as 6.21401E+15. If I fomat it as text, it appears as 6214008046176060. Is there an easy way around this short of saving it as a ..txt file and then using TEXT TO COLUMNS when re-opening it Another example, 1234567890987654321 appears as 1234567890987650000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto resize when insert large image to excel | Excel Worksheet Functions | |||
| Rounding a large range & a Missing Font | New Users to Excel | |||
| Decimal Places - Settings for Auto Rounding Up/Down | Excel Worksheet Functions | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Excel,Auto fit - does work for large text fields | Excel Discussion (Misc queries) | |||
Threaded Mode
