Currency Formatting

G

Guest

I have a workbook with various worksheets in it. When I add an amount into a
cell
and ENTER, the Dollar sign appears even though if I right click and select
FORMATT CELLS and select CURRENCY, NONE appears in the sected currency box.

If I open a new EXCEL sheet outside of that workbook and enter an amount
into a cell and ENTER, the Pound sign appears! Any suggestions?
 
M

moi

If you right click, select Format Cells, you will also see Financial.
There's a dollar-sign too, so did you also check that?
 
G

Guest

I don't see a Financial in the list, there is an Accounting which I have
checked that the £ sign is selected.
 

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

Top