Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a custom format that will multiply, say, $0.25 by 100 and show it as
25¢? (By analogy, placing a comma after the final zero in the custom format and adding the letter K will divide the number by 1,000 to make 1,000,000 look like 1,000K so I hope I can made numbers less than $1 appear as ¢ without leading decimals.) Stephen Powell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Time Format doesn't work for me | Excel Discussion (Misc queries) | |||
Custom Number Format... | Excel Worksheet Functions | |||
Custom Format and Data Validation Q | Excel Worksheet Functions | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
custom format | Excel Worksheet Functions |