Formatting issues

  • Thread starter Thread starter NICHOLE
  • Start date Start date
N

NICHOLE

Is there a way to do this easily? I have a number 00044109
and what I need it to say is $441.09. Is there a way to
have it automatically put a decimal point two places in
from the end? I have many numbers I need to do this to.
Thanks for any suggestions.

Nichole
 
Nichole,

Enter 0.01 in some empty cell and copy this. Then select the cells you want
to change. Go to the Edit menu, choose Paste Special, and choose the
Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Hi Nichole,

Put 100 in a cell somewhere and copy it. Then select your data, and Edit |
Paste Special - Operation Divide. Then just format with $.

HTH

Regards,
Kevin
 
Put 100 in an empty cell somewhere, copy the cell, select all your data and do
Edit / Paste Special / Divide. Then Format the ecells as Currency and choose a
$ sign.
 
Back
Top