ExcelBanter - CONVERT DATA TO CURRENCY FORMAT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CONVERT DATA TO CURRENCY FORMAT (https://www.excelbanter.com/excel-discussion-misc-queries/3601-convert-data-currency-format.html)

roy in sunbury

CONVERT DATA TO CURRENCY FORMAT

how to convert multi decimal place data in colums to 2 decimal places incl.
zeros

akk

Format cells - select number - choose the format you want
and enter the number of decimal places in the proovision
above.

-----Original Message-----
how to convert multi decimal place data in colums to 2
decimal places incl.
zeros
.

All times are GMT +1. The time now is 07:18 AM.