Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Currancy Decimals
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Currancy Decimals
On Oct 16, 6:44*am, sunni1960
wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Currancy Decimals
On Sun, 16 Oct 2011 06:44:21 -0500, sunni1960 wrote:
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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Currancy Decimals
On 10/16/2011 at 6:44:21 AM sunni1960 wrote:
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 -- tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count digits before decimals and after decimals | Excel Worksheet Functions | |||
Excel - decimals | Excel Discussion (Misc queries) | |||
Set automatic currancy decimal without entering the decimal? | Excel Worksheet Functions | |||
Excel: How can I get numbers without decimals ? | New Users to Excel | |||
Bug - Decimals in Excel Worksheet | Excel Discussion (Misc queries) |