| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make a whole number
Thank you the Round worked GREAT!!!!!
"Toppers" wrote: =ROUND(A1,2) "sbhayes" wrote: I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| make cell entries a negative number | New Users to Excel | |||
| make negative number value to zero | Excel Worksheet Functions | |||
| make negative number value to zero | Excel Worksheet Functions | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Threaded Mode
