| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reformatting numbers
I received a worksheet with numbers derived from formulas in the cells. I
converted the formulas to values so I was left with only the results of the formula. However, the numbers have about eight digits after the decimal point. How do you eliminate all decimal places after the first two? I'm using an old 1997 Excel version. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| Validating random numbers | Excel Worksheet Functions | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions | |||
Threaded Mode
