Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the value in different format?
There is a number in cell A1, which is selected from a list
0.01, 0.1, 1, 10, 100, 1000 There is a given number 654.356 in cell B1 Does anyone have any suggestions on how to display the value in different format? For example, If the number in cell A1 is 0.01, then 654 should be displayed in cell C1. If the number in cell A1 is 0.1, then 654 should be displayed in cell C1. If the number in cell A1 is 1, then 654 should be displayed in cell C1. If the number in cell A1 is 10, then 654.3 should be displayed in cell C1. If the number in cell A1 is 100, then 654.36 should be displayed in cell C1. If the number in cell A1 is 1000, then 654.356 should be displayed in cell C1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display #'s incorrectly (format) | Excel Discussion (Misc queries) | |||
Display time format | Excel Discussion (Misc queries) | |||
How to display 5 into May in mmm format? | Excel Discussion (Misc queries) | |||
Cell format, want 100 to display as 1.00 | Excel Discussion (Misc queries) | |||
Display 0's in Accounting format | Excel Discussion (Misc queries) |