Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Convert whole numbers to decimals

Posted by Jessica on June 15, 2001 2:16 PM

I can't figure out how to convert a whole number to a decimal in Excel 2000 (I have a column of whole numbers that needs to be in decimals.)

ie. Convert 110550 to 1105.50

I'm sure this is easy but I've been searching and can't find an answer.

Thanks!

Re: Convert whole numbers to decimals

Posted by Mark W. on June 15, 2001 2:22 PM

Enter 100 into an unused cell, Copy it, select the
cells containing your values, perform
an Edit | Paste Special... clicking the "Values" and
"Divide" radio buttons, and press [ OK ].

Re: Convert whole numbers to decimals

Posted by Jessica on June 15, 2001 2:48 PM

Thanks a million..that worked!
=====

Another way

Posted by Jerid on June 18, 2001 6:56 AM

Another way would be to Multiply the number by .01

Jerid

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.