Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal
Hi,
I had a file with some figure with have different decimal pt. If I use format cell it show 2 decimal but the actual cell still have more than 2 decimal. I wish to round up to 2 decimal and also the actual cell only show 2 decimal. 185.0000 1.48803125 275.286 16.517 170.0000 2.13408612 362.795 1.768 500.0000 0.8612726 430.636 25.838 220.0000 0.97610038 214.742 12.885 30000.0000 0.0155231 465.693 27.942 904.0000 2.6159168 2,364.789 141.887 100.0000 0.41724134 41.724 2.503 1.0000 0.21278913 0.213 0.013 1.0000 0.19200455 0.192 0.012 1.0000 0.0010763 0.001 0.009 1.0000 1.28738127 1.287 0.077 1.0000 0.02786532 0.028 0.002 3472.0000 1.000000 3,472.000 208.320 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set automatic currancy decimal without entering the decimal? | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |