Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing a FIXED Function
I need to know how remove a FIX function. At the bottom right corner of my
worksheet, the word FIX is present. Everything that is enetered is rounded off. For exmple, if I key the following # 123 it then reads 1.23 with 2 decimal places. If I key the same # with the formatting reading no decimal places, then 123 entered rounds to 1. I the same sense, if I key in a 2 digit # like 12 the upon entering the # appears as .12 with 2 decimal places. If it is formatted to no decimal places then it rounds to 0 (zero). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |