$ in Excel cells won't appear

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

Guest

I have imported some numbers from a data base and would like to convert them
into $. I select the entire column, click on $, but nothing happens. The
numbers don't change with the dollars sign in front of them. The numbers ONLY
change when I select each individual cell and press ENTER.
 
The numbers from the data base were likely imported as text values. Thus,
applying a new number format will have no effect until the data is re-entered.

To easily convert all of the text values to numbers:

Enter a 1 into any blank cell
Copy that cell
Select your range of data to convert
From the Edit Menu, select "Paste Special..."
Click the "Values" and "Multiply" options
Click OK
Delete the 1 you entered originally

You should now be able to apply new number formats to your data.

HTH,
Elkar
 
I have imported some numbers from a data base and would like to convert them
into $. I select the entire column, click on $, but nothing happens. The
numbers don't change with the dollars sign in front of them. The numbers ONLY
change when I select each individual cell and press ENTER.
Click to expand...


What version of Excel are you using? I have had this issue before
with '03. To correct it, go to tools>options and on the calculation
tab make sure that 'automatic' is selected. If it is set to manual,
you will have to do what you are currently are doing.
 
Dear Elkar,
Thank you for your precise, fast, and efficient answer. IT WORKED!
Thanks a million..
 
Back
Top