currency format

J

Jon

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make a new currency symbol 5
Cell not calculating after importing data 2
News Bank of England considers digital currency 4
HELP - A formula or sheet you want to move or copy contains the name .... 0
Stop XL from changing format? 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
How to add new currency Symbol in Format/Cell/Currency 2
Comma separator for custom Currency 0

Top