| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why value comes with 10 digit after . (.)?
I copy data from one website and paste it to excel sheet. The value which is
copied is like 180.12098400983000, 20.000002300000, 79.120000, 130.25999999999999 like this, i have so many data. I can't do formate cell number check 1234.10. each time. Infact, formate cell number check 1234.10, this process also not any result. i want to do it with a click or two. Someone pls suggest |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| Sorting a six digit number by terminal digit | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
![Harshad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
