Decimals on cents

S

sunni1960

Hello
I set up a sheet for excel to add my total then apply tax then total amoun
everything is working fine except when it calculates the 6 percent sales ta
i
looks like this 125 instead of 1.25 or 50 instead of .50 I could use som
help
thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Currancy Decimals 3
Excel not totaling right amount 4
out 2 cents - auto rounding? 7
WHEN I TOTAL A COLUMN I GET A RESULT IN WRONG FORMAT 2
Extracting Data from Tables 1
Need Year-To-Date Sum Function with nested Vlookup and offset 3
Report totals off by a couple cents. 4
is this possible in excel 2007 3

Top