Formatting issues

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
 
C

Chip Pearson

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 [email protected]
 
K

Kevin Stecyk

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
 
K

Ken Wright

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.
 
Top