Conver to $

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Hi

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