| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To stop the rounding of numbers
I'm trying to setup a golf handicaping worksheet and I'm stuck trying to
figure out how to display a number that has not been rounded. After I have done my formulas to arrive at a number that has 4 numbers past the decimal point I'm supposed to get rid of all the numbers accept the first one past the decimal point without rounding. I'm looking to hide the column with the 4 places and display a column with the unrounded number. This cant be as difficult as it seems. Thanks Frank |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To stop the rounding of numbers
=TRUNC(A1,1)
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "franke" wrote in message ... I'm trying to setup a golf handicaping worksheet and I'm stuck trying to figure out how to display a number that has not been rounded. After I have done my formulas to arrive at a number that has 4 numbers past the decimal point I'm supposed to get rid of all the numbers accept the first one past the decimal point without rounding. I'm looking to hide the column with the 4 places and display a column with the unrounded number. This cant be as difficult as it seems. Thanks Frank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get excel to stop rounding numbers | Excel Discussion (Misc queries) | |||
| Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
| How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
| How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
| How do I stop rounding numbers? | Excel Discussion (Misc queries) | |||
Hybrid Mode
