How do I format cells to round to the nearest thousands without ..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

using the Round Function. It seems like there should be a way to format
numbers that are already entered into cells.Thanks!
 
On Wed, 16 Mar 2005 09:55:03 -0800, "excel user" <excel
using the Round Function. It seems like there should be a way to format
numbers that are already entered into cells.Thanks!
Click to expand...

You can format the numbers -- this will not change their values. In other
words, 23,501 can be formatted to look like 24 or 24,000. However, the value
in the cell will remain 23,501 and will behave as such in calculations that
reference the cell.

To format 23501 as 24:

Format/Cell/Number/Custom Type: #,

To format 23501 as 24,000

Format/Cell/Number/Custom Type: #,",000"


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average rounded to nearest 0.50 4
Format cell to the nearest 100 4
rounding up to nearest specified whole number 1
Round time to nearest 15 minutes in decimal format 4
Rounding to nearest 0.5 in Excel 2007 4
round up to nearest 50p 1
format to round down 2
How can I Round up to the nearest .25 11

Back
Top