Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
O Wayne
 
Posts: n/a
Default EXCEL HAS STARTED ROUNDING TO THE WHOLE DOLLAR

I am doing a time sheet and when I multiply the hours by the rate sometimes
the result keeps cents and sometimes it rounds to dollars.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default EXCEL HAS STARTED ROUNDING TO THE WHOLE DOLLAR

What is your formula, what are the input values and what result do you get?
How is the cell formatted? What happens if you format the cell General?

--
Kind regards,

Niek Otten

"O Wayne" <O wrote in message
...
I am doing a time sheet and when I multiply the hours by the rate sometimes
the result keeps cents and sometimes it rounds to dollars.



Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
why is excel rounding my totals down Lisa Excel Discussion (Misc queries) 8 September 26th 05 02:01 PM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
Rounding off numbers in Excel 2003 Joe Tahoe Excel Worksheet Functions 4 July 28th 05 03:08 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 05:28 PM.

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"