I type in a number in a cell but it wont convert to currency help

O

Out in VA

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
 
F

Fred Smith

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
 
O

Otto Moehrbach

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
 

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
Convert number to word in indian currency 2
Convert currency to general 12
: In Access( Excel), how can I convert currency to words? 1
Format Currency Cell 6
Number Formatting in a concatenated cell 3
Format Currency in-cell 2
Summary of Unique item values 2

Top