On Feb 27, 2:07 pm, SpaceCoorDinator
wrote:
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.


What version of Excel are you using? I have had this issue before
with '03. To correct it, go to toolsoptions 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.