| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Big problem.................
I have the following data,
1. 103 2. 1002 3. 205 The last digit of above number represent how many zero it is. 103 equal to 10000 (10K), 1002 equal to 10000 (10k), 205 equal to 2000000(2M) How to use the function to change 103 to 10K, 1002 to 10K, 205 to 2M ? In fact, not only these number , other number I want to change contain ............3491 change to 3.49K, 121 change to 120 ,etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Threaded Mode
