Currency format in Excel

S

simon

Excel 2000

Can i adjust the order of currency symbols in the cell format drop-down box

Thanks in advance
 
S

simon

I regularly need to use the Bulgarian Lb symbol and it is way down on the
list, is it possible to remove some of the unused symbols or can you suggest
a shortcut

regards

Simon
 
G

Gord Dibben

Format>Style>Currency>Modify.

Make your changes here.

Click on the Currency Icon on Formatting Toolbar to get the choice for selected
cell(s)

Note: this is a workbook only style, not global.


Gord
 

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 add currency symbol to a cell value 3
Yen currency symbol 4
How to add new currency Symbol in Format/Cell/Currency 2
Stop XL from changing format? 1
Find and Replace 4
My cell format changes unexpectedly after copy/paste 1
Default Cell format of existing Worksheets got changed automatical 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Top