| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format question
I am using Excel 2007. If I type .01 in a cell, I want the format to return
showing "1 Basis Point" (no quotes needed). If I type .035, I wish to have the cell show "3.5 Basis Points". The plural/non plural would be nice, but showing either would be fine. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Question: Show percentages and standard number format | Excel Discussion (Misc queries) | |||
| Simple Question, display only part of a date in Number format | Excel Worksheet Functions | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| Custom Number format question | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Threaded Mode
