| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format to Round to Tens Digit
I want to format the numbers to round from 1,536 to 1540. I can only find how
to round multiples of a thousand with the custom formats and I am wondering if there is a way to do this. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to Round to Tens Digit
Andy
A format will only alter the display, why not use a formula like =ROUND(A1,-1) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Andy" wrote in message ... I want to format the numbers to round from 1,536 to 1540. I can only find how to round multiples of a thousand with the custom formats and I am wondering if there is a way to do this. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to Round to Tens Digit
How about:
=round(1536/10,0)*10 Mike "Andy" wrote: I want to format the numbers to round from 1,536 to 1540. I can only find how to round multiples of a thousand with the custom formats and I am wondering if there is a way to do this. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to Round to Tens Digit
No, I would like to copy and paste values into a cell and have them display
rounded off to the tenths digit. "Mike" wrote: How about: =round(1536/10,0)*10 Mike "Andy" wrote: I want to format the numbers to round from 1,536 to 1540. I can only find how to round multiples of a thousand with the custom formats and I am wondering if there is a way to do this. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to Round to Tens Digit
Tue, 29 May 2007 12:20:01 -0700 from Andy
: I want to format the numbers to round from 1,536 to 1540. I can only find how to round multiples of a thousand with the custom formats and I am wondering if there is a way to do this. Look up the ROUND function. =ROUND(..., -1) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round Up by a factor not by a digit [MROUNDUP(number,multiple)] | Excel Worksheet Functions | |||
| On Excel I need to round up in tens of thousands | Excel Discussion (Misc queries) | |||
| Format divide by 10 / single digit view: Custom? Text(Round( | Excel Discussion (Misc queries) | |||
| Does Excel round numbers with a 5 in the tens place? | Excel Discussion (Misc queries) | |||
| WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
Linear Mode
