| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Significant figures
I would like a conditional format that would change the number of digits
after the decimal point depending on whether the number was in the 10's, 100's or 1000's For example 1.02 would give 1.02 10.05 would give 10.05 100.13 would give 100.1 1004.13 would give 1004 10054 would give 10050 Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i show 3 significant figures | Excel Discussion (Misc queries) | |||
| significant figures | Excel Worksheet Functions | |||
| significant figures? | Excel Discussion (Misc queries) | |||
| Rounding/Significant figures | Excel Worksheet Functions | |||
| pls help newbie with my significant figures function | Excel Programming | |||
Threaded Mode
