ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   EXCEL HAS STARTED ROUNDING TO THE WHOLE DOLLAR (https://www.excelbanter.com/excel-discussion-misc-queries/68847-excel-has-started-rounding-whole-dollar.html)

O Wayne

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.

Niek Otten

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.





All times are GMT +1. The time now is 01:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com