Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |