Prev: Fill last row down for large selection?
Next: Date Help
From: Out in VA Out in on 27 May 2010 17:34
I copied and pasted a worksheet from old version of excel into the new 2007
and when I type a number in a cell and try to convert it to currency
--_NOTHING happens....no matter what I do....it will not change to
currency????

Please help
From: Fred Smith on 27 May 2010 18:48
How are you converting it to currency? By formatting the cell?

If the cell is originally text, you need to change the format first, then
enter your data.

Regards,
Fred

"Out in VA" <Out in VA(a)discussions.microsoft.com> wrote in message
news:9E53E977-A30D-42A3-BBD3-A6F708BFAFBC(a)microsoft.com...
>I copied and pasted a worksheet from old version of excel into the new 2007
> and when I type a number in a cell and try to convert it to currency
> --_NOTHING happens....no matter what I do....it will not change to
> currency????
>
> Please help

From: Otto Moehrbach on 27 May 2010 19:04
Give us specifics. You type a number into a cell. What number? What cell?
Exactly what do you do to "convert it to currency"? Be specific. I click
here. I click there, etc, etc, etc. Otto

"Out in VA" <Out in VA(a)discussions.microsoft.com> wrote in message
news:9E53E977-A30D-42A3-BBD3-A6F708BFAFBC(a)microsoft.com...
> I copied and pasted a worksheet from old version of excel into the new
> 2007
> and when I type a number in a cell and try to convert it to currency
> --_NOTHING happens....no matter what I do....it will not change to
> currency????
>
> Please help

 | 
Pages: 1
Prev: Fill last row down for large selection?
Next: Date Help