| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change number from multiple decimals to 2
Can someone please help me figure out how to change a number that has
multiple declimal places (example 54.123456) to only 2 places (example 54.12). When I format the number to 2 decimals, it appears correct, however, when I "click" on the number, it still shows the multiple decimals. I need the number to only show 2 decimal places at all times. Any suggestions would be greatly appreciated! -- Diana |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number from multiple decimals to 2
You can use Tools | Options | Calculation tab and then click on
Precision as displayed - when you click OK Excel will warn you that you are about to change values, and that this is not reversible. Hope this helps. Pete On Oct 22, 5:06*pm, DianaC wrote: Can someone please help me figure out how to change a number that has multiple declimal places (example 54.123456) to only 2 places (example 54.12). *When I format the number to 2 decimals, it appears correct, however, when I "click" on the number, it still shows the multiple decimals. *I need the number to only show 2 decimal places at all times. *Any suggestions would be greatly appreciated! -- Diana |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number from multiple decimals to 2
=ROUND(A2,2)
-- David Biddulph "DianaC" wrote in message ... Can someone please help me figure out how to change a number that has multiple declimal places (example 54.123456) to only 2 places (example 54.12). When I format the number to 2 decimals, it appears correct, however, when I "click" on the number, it still shows the multiple decimals. I need the number to only show 2 decimal places at all times. Any suggestions would be greatly appreciated! -- Diana |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number from multiple decimals to 2
Use the round function: =round(54.123456,2). The second input to the function tells it to round to the second decimal place. Don "DianaC" wrote: Can someone please help me figure out how to change a number that has multiple declimal places (example 54.123456) to only 2 places (example 54.12). When I format the number to 2 decimals, it appears correct, however, when I "click" on the number, it still shows the multiple decimals. I need the number to only show 2 decimal places at all times. Any suggestions would be greatly appreciated! -- Diana |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change feet/ inches to decimals | Excel Discussion (Misc queries) | |||
| Change number of decimals but retain original style | Excel Discussion (Misc queries) | |||
| Whole Number and Decimals | Excel Discussion (Misc queries) | |||
| How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
| change 5523.44 to 552344 no decimals | Excel Worksheet Functions | |||
Linear Mode
