| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format not working
Hello this is my custom number format [<1]0.00%;$#,##0.00
If I enter the number 5 I get 5.00% if I enter 100.00 I do not Get $100.00 I get $1.00 This is what i'm trying to do. anything from1 to 5 should be in % above 5 should be in $ thanks thanks thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format Not Working | Excel Worksheet Functions | |||
| Currency format not working | Excel Discussion (Misc queries) | |||
| i'm trying to put a value with a number but its not working. | Excel Worksheet Functions | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| format-row-autofit not working | Excel Worksheet Functions | |||
Threaded Mode
