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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format question
A1 being the referenced cell, the formula would be written thus:
=CONCATENATE(text(A1*100,"0.0")," Basis Point",IF((a1*100)1,"s","")) "BobK" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format question
If your nos are in Col A with header rows then enter this in B2 and copy down
=A1*100 & " Basis Points" If you want the formats, as mentioned, then you will have to enter values as 1, 35,.. and use the CUSTOM FORMAT as #.# "Basis Points";; Remove both ;; if you will enter 0 as a valid value and want to see 0 Basis Points... "BobK" wrote: 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! |
Reply |
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) |