LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count digits before decimals and after decimals Elton Law[_2_] Excel Worksheet Functions 5 April 3rd 23 10:59 AM
Excel - decimals school girl Excel Discussion (Misc queries) 3 April 20th 10 08:37 PM
Set automatic currancy decimal without entering the decimal? Giesej Excel Worksheet Functions 3 March 2nd 09 12:09 AM
Excel: How can I get numbers without decimals ? Wamalapada New Users to Excel 2 April 9th 05 01:43 PM
Bug - Decimals in Excel Worksheet Ian Excel Discussion (Misc queries) 2 February 15th 05 03:50 PM


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"