Dollar sign won't show in Excel 2002 SP3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

An imported file has a column that should be displayed as currency. Whether
from the $ sign on the toolbar or via Format|Cells|Number|Currency I cannot
get the $ sign to show.

I've tried copying the column to a worksheet where this works and the
problem remains. I also did a "Repair Application" from Add/Remove Programs
and this made no difference. I also tried Format|Style|Merge from a
worksheet with the correct currency style and this did not work either.
 
Maybe it's a windows setting (just a guess, though).

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab

What do you see for the currency symbol?
 
It may be that the numbers are really text.

Have you tried working with them as numbers, like Summing them?

If text, format to General then copy an empty cell.

Select your range of numbers and Paste Special>Add>OK>Esc.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Format currency in MsgBox 3
Dollar sign alignment - Accounting vs Currency style 3
#VALUE on data copied from web page 4
Show data depending on value 2
Need help with formating cell 3
changing currency 1
Sum won't show 3

Back
Top