Decimal Formual
 

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

Decimal Formual
 

Try this:

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

EditPaste Special
Check: Values
Check: Multiply
click the [OK] button

Does that help?

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

XL2002, WinXP-Pro


"Sandi" wrote:

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

Decimal Formual
 

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: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=511032

Decimal Formual
 

RON - HOW AWESOME ARE YOU!!!!!!!

Works like a charm!!!!!!!
--
Sandi Gardner


"Ron Coderre" wrote:

Try this:

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

EditPaste Special
Check: Values
Check: Multiply
click the [OK] button

Does that help?

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

XL2002, WinXP-Pro


"Sandi" wrote:

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