Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Is there a way in Excel to change percentages, i.e. sales tax [ex. 5%], to
the currency equivalation of the sales tax? -- Anita R. |
#2
![]() |
|||
|
|||
![]()
type 0.05 and format as currency, I don't see any purpose doing this
though, if you want the amount of sales tax just multiply with 5% =A1*5% or =A1*(1+5%) for total price and format result as currency -- Regards, Peo Sjoblom (No private emails please) "Anita" wrote in message ... Is there a way in Excel to change percentages, i.e. sales tax [ex. 5%], to the currency equivalation of the sales tax? -- Anita R. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
dates change to numbers | Excel Worksheet Functions | |||
how to change numbers into words, | Excel Discussion (Misc queries) | |||
How do I set "y" axis to numbers and labels to percentages on my . | Charts and Charting in Excel | |||
Change row numbers | Excel Discussion (Misc queries) |