ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to get the rounding function off (https://www.excelbanter.com/excel-worksheet-functions/29225-how-get-rounding-function-off.html)

Cynthia A

how to get the rounding function off
 
I work with excel and I need to NOT have the rounding function on. For
example 6,14 should remain as such and not be 6.00 HelP!

Peo Sjoblom

There is no such thing, there is a ROUND function but it has to be applied
through a formula

=ROUND(Cell,2)

as an example

also you are using 6,14 are you using European delimiters with a comma for
decimals or did you mean 6.14? If you have fixed decimal places turned on
under toolsoptionsedit, it will change input when you enter a value

--
Regards,

Peo Sjoblom

(No private emails please)


"Cynthia A" <Cynthia wrote in message
...
I work with excel and I need to NOT have the rounding function on. For
example 6,14 should remain as such and not be 6.00 HelP!




All times are GMT +1. The time now is 05:19 AM.

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