| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ROUND DATA TO 2 DECIMAL PLACES
i want to convert multi decimal place data to 2 decimal places including
showing zeros. Old excell used currency formula- cant find how on latest office. Help |
|
#2
|
|||
|
|||
|
Roy,
Put your curser in the cell that contains the number you want to round. Go to the standard toolbar and click on Format - Cells - Number Tab - and choose the format that you want (Currency, Number, etc.). There is an input for how many decimals that you want to round your number to here also. ---- Regards, John Mansfield http://www.pdbook.com "roy in sunbury" wrote: i want to convert multi decimal place data to 2 decimal places including showing zeros. Old excell used currency formula- cant find how on latest office. Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Linear Mode
