how to get the rounding function off

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round Function 5
Round Off 2
Round it off 3
How to round & sum only the displayed (rounded) numbers 2
Rounding Up question 2
Round Down to the nearest multiple 2
Round Function Philosophy 17
Footing rounded numbers 4

Back
Top