how to get the rounding function off

C

Cynthia A

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!
 
P

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 tools>options>edit, it will change input when you enter a value

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top