ExcelBanter - currency format

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

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

- - currency format (https://www.excelbanter.com/excel-discussion-misc-queries/225877-currency-format.html)

Jon

currency format

I would like to have the format of my cell displaying as:

'Lm' + #,##0.00

'Lm' is the currency required (Maltese lira).

Any idea how to do it?

Sheeloo[_4_]

currency format

Format your cells choosing 'Custom format' as
"Lm" #,##0.00

"Jon" wrote:

I would like to have the format of my cell displaying as:

'Lm' + #,##0.00

'Lm' is the currency required (Maltese lira).

Any idea how to do it?

All times are GMT +1. The time now is 05:29 PM.