| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and dropping digits
Marissa Sorry. Initially I read this as 567.549 instead of comma....
Gord has answered this..Cheers If this post helps click Yes --------------- Jacob Skaria "Marissa" wrote: Thank you but it did not work. The result was the number in A1. "Jacob Skaria" wrote: A1 = 567,549 =ROUND(A1,0) If this post helps click Yes --------------- Jacob Skaria "Marissa" wrote: Hello, Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up or down to specific decimal digits. | Excel Worksheet Functions | |||
| Excel is rounding off more than 16 digits ? | Excel Discussion (Misc queries) | |||
| How to truncate to tenths digits without rounding | Excel Worksheet Functions | |||
| excel, how enter 15 digits in a cell without rounding off last? | Excel Worksheet Functions | |||
| How do I keep Excel from dropping my numbers to 0 after 15 digits | Setting up and Configuration of Excel | |||
Threaded Mode
