Excel Currancy Decimals

[sunni1960]

Hello
I set up a worksheet to add my totals, put the tax on, round up and then gran
total. Everything is working fine except the tax total does not have an
decimals if the total is 1.24 it looks like 124 or .50 cents looks like 50 an
help would be appreciated.

 

[Don Guillett]

Hello,
 I set up a worksheet to add my totals, put the tax on, round up and then grand
 total. Everything is working fine except the tax total does not have any
 decimals if the total is 1.24 it looks like 124 or .50 cents looks like 50 any
 help would be appreciated.

maybe you didn't apply the tax right?. Or, divide by 100

 

[Stan Brown]

Hello,
I set up a worksheet to add my totals, put the tax on, round up and then grand
total. Everything is working fine except the tax total does not have any
decimals if the total is 1.24 it looks like 124 or .50 cents looks like 50 any
help would be appreciated.

Please don't post the same query multiple times.

You are using 6 (or whatever) for the tax rate, instead of 6%. Use
6% in your formula, and all will be well.

 

[tb]

Hello,
I set up a worksheet to add my totals, put the tax on, round up and
then grand total. Everything is working fine except the tax total
does not have any decimals if the total is 1.24 it looks like 124 or
.50 cents looks like 50 any help would be appreciated.

Select the cell with the tax total
Right-click it
Choose Format Cell...
In the Category column, pick either Number or (even better) Currency
Specify the number of decimals
Click OK