Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
c-swym
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bearacade
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Paul Mathews
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
c-swym
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel evaluate a series of numbers Chad Sellers Excel Discussion (Misc queries) 6 November 11th 05 11:42 AM
How do I sort letters before numbers in Excel? RiverGirl Excel Discussion (Misc queries) 4 May 27th 05 04:09 PM
stop excel from rounding a result Hazeldean Excel Worksheet Functions 3 May 13th 05 10:42 PM
How do I stop Excel from changing simple numbers to their 1/100th. Chris C Excel Discussion (Misc queries) 1 December 14th 04 08:14 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"