Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
I would like to be able to shut off the rounding function in excel. For
example: the number $1,428.627 I would like to have show up as $1,428.62. Any help would be appreciated. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
You could use the ROUNDDOWN function in another cell
=ROUNDDOWN(A1,2) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "c-swym" wrote in message ... I would like to be able to shut off the rounding function in excel. For example: the number $1,428.627 I would like to have show up as $1,428.62. Any help would be appreciated. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
Right click on the cell(s) you need to change, select format cells, in the Number Tab, select Currency, and select 3 in the decimal place -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551636 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
Is it rounding or not, your description is confusing?
If you seen $1,428.627, it is not rounding. If you want to see it to 2 dec pl., just set it to currency format, FormatCellsCurrency. This will stil have the .007 in the number and will add that into any subsequent sums etc. You can avoid this by rounding within the sum, such as =SUM(ROUND(A1:A2,2)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "c-swym" wrote in message ... I would like to be able to shut off the rounding function in excel. For example: the number $1,428.627 I would like to have show up as $1,428.62. Any help would be appreciated. Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
"c-swym" wrote in message
... I would like to be able to shut off the rounding function in excel. For example: the number $1,428.627 I would like to have show up as $1,428.62. Any help would be appreciated. Thank you. If you merely want to display with 2 decimal places but retain the full precision, the Format/ Cells/ Number, and select 2 decimal places. If you actually want to change the value, then use the formula =ROUND(A1,2) -- David Biddulph |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
Use the truncate function. For example, if cell A1 = 1428.627, set cell B1
(or whereever you'd like the result) to =TRUNC(A1,2). This just truncates the value to the indicated number of decimal places. "c-swym" wrote: I would like to be able to shut off the rounding function in excel. For example: the number $1,428.627 I would like to have show up as $1,428.62. Any help would be appreciated. Thank you. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding numbers?
The response from Paul Mathews was the answer I was looking for and worked
perfectly. Thank you! "c-swym" wrote: I would like to be able to shut off the rounding function in excel. For example: the number $1,428.627 I would like to have show up as $1,428.62. Any help would be appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel evaluate a series of numbers | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
stop excel from rounding a result | Excel Worksheet Functions | |||
How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) |