Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding numbers in XL
How can I...
round up or down a a price to the nearest dollar and leave no decimal points? I have treid formatting the cell so it doesn't show the cents but the value still exists as a number in excel. I want to show just the whole dollar amount with no change but I need to do it in one sweeping change to a huge price list. How can I do that while highlighting the work??? Oh yeah, I can't show any formulas later. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding numbers in XL
Sean
Use a helper column, say F and if the existing prices are in column A then in F1 enter =ROUND(A1,0) Copy this down column F and then copy this column and editpaste special... Values over column A, you can now delete column F -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sean Lambertz" wrote in message ... How can I... round up or down a a price to the nearest dollar and leave no decimal points? I have treid formatting the cell so it doesn't show the cents but the value still exists as a number in excel. I want to show just the whole dollar amount with no change but I need to do it in one sweeping change to a huge price list. How can I do that while highlighting the work??? Oh yeah, I can't show any formulas later. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding numbers in XL
Assuming in A
B1: =ROUND(A1,0) copy down select column B copy EditPasteSpecial, click Values OK Delete column A -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Sean Lambertz" wrote in message ... How can I... round up or down a a price to the nearest dollar and leave no decimal points? I have treid formatting the cell so it doesn't show the cents but the value still exists as a number in excel. I want to show just the whole dollar amount with no change but I need to do it in one sweeping change to a huge price list. How can I do that while highlighting the work??? Oh yeah, I can't show any formulas later. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding numbers in XL
"Sean Lambertz" wrote in message
... How can I... round up or down a a price to the nearest dollar and leave no decimal points? I have treid formatting the cell so it doesn't show the cents but the value still exists as a number in excel. I want to show just the whole dollar amount with no change but I need to do it in one sweeping change to a huge price list. How can I do that while highlighting the work??? Oh yeah, I can't show any formulas later. =ROUND(A1,0) If you don't want to show the formula, Cut, then Paste Special/ Values. -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding numbers in XL
Hi Sean,
You could use Tools|Options and check 'precision as displayed'. Although the cells will still contain the decimal values, you won't see them and they'll be rounded off in any calculations. No need to select anything. Cheers "Sean Lambertz" wrote in message ... How can I... round up or down a a price to the nearest dollar and leave no decimal points? I have treid formatting the cell so it doesn't show the cents but the value still exists as a number in excel. I want to show just the whole dollar amount with no change but I need to do it in one sweeping change to a huge price list. How can I do that while highlighting the work??? Oh yeah, I can't show any formulas later. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
how to loose all numbers after decimal (not rounding) | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |