View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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