software

I have a worksheet with numbers such as 175, 163, 250 etc. Is there a
formula without going back in and retyping all of these numbers that can turn
them into a decimal number like this: 1.75, 1.63, 2.50. I've tried to
multiply the cell by .01 but when I copy the formula down, it just copies
just the result of that cell -

Any help would be appreciated!!!! Thanks!
--
Sandi Gardner

Try this:

Put 0.01 in an empty cell
Copy that cell
Select the numbers that you want to be impacted.

Editgt;Paste Specialgt;
Check: Values
Check: Multiply
click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Sandiquot; wrote:

gt; I have a worksheet with numbers such as 175, 163, 250 etc. Is there a
gt; formula without going back in and retyping all of these numbers that can turn
gt; them into a decimal number like this: 1.75, 1.63, 2.50. I've tried to
gt; multiply the cell by .01 but when I copy the formula down, it just copies
gt; just the result of that cell -
gt;
gt; Any help would be appreciated!!!! Thanks!
gt; --
gt; Sandi Gardner


Sandi,

Type .01 into a cell. Copy that. Highlight the entire range of values
you want to multiply by .01. Paste Special - Multiply.

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=511032RON - HOW AWESOME ARE YOU!!!!!!!

Works like a charm!!!!!!!
--
Sandi Gardnerquot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Put 0.01 in an empty cell
gt; Copy that cell
gt; Select the numbers that you want to be impacted.
gt;
gt; Editgt;Paste Specialgt;
gt; Check: Values
gt; Check: Multiply
gt; click the [OK] button
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Sandiquot; wrote:
gt;
gt; gt; I have a worksheet with numbers such as 175, 163, 250 etc. Is there a
gt; gt; formula without going back in and retyping all of these numbers that can turn
gt; gt; them into a decimal number like this: 1.75, 1.63, 2.50. I've tried to
gt; gt; multiply the cell by .01 but when I copy the formula down, it just copies
gt; gt; just the result of that cell -
gt; gt;
gt; gt; Any help would be appreciated!!!! Thanks!
gt; gt; --
gt; gt; Sandi Gardner