|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 27th, 2010, 10:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I type in a number in a cell but it wont convert to currency help
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 
|
|
#2
May 27th, 2010, 11:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I type in a number in a cell but it wont convert to currency help
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 wrote in message ... 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
|
|
#3
May 28th, 2010, 12:04 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I type in a number in a cell but it wont convert to currency help
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 wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
