Conver to $

G

Guest

How do I convert a column of numbers to currency? The
numbers are already existing. If I choose currency it
adds a decimal and 2 zeros. That does not work. I need
to add a decimal to the existing numbers.
Can any one HELP?
Thanks in advance
Bob B
 
A

Arvi Laanemets

Hi

Enter 0.01 into some cell and copy it
Select your numbers, and then PasteSpecial.Multiply
Format your data as currency
 

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

Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Autonumber field in Excel that behaves the same as Access 0
How can the font and size of (all) citation numbers be altered? 1
Word- Find and Replace 1
Decimal point in general format 1
Finding the proper style field and the numbered paragraph value within the style 0
Sum Function has small remainder 2

Top