Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting 2-place decimal value to floating point decimal number with leading zero
Hello,
I thought this would be simple, but, what I'm trying to do is take a column of numbers like this: 7.25 7.00 8.25 7.75 and convert them to this: 0.0725 0.0700 0.0825 0.0775 I am using Excel 2000 and have gone through all the format options but can't find anything that will do the trick. If someone could show me how to do this it would ge greatly appreciated. Thanks in advance, KP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting 2-place decimal value to floating point decimal number with leading zero
7.25/100=.0725
do this in another column and delete the earlier column "Kermit Piper" wrote in message oups.com... Hello, I thought this would be simple, but, what I'm trying to do is take a column of numbers like this: 7.25 7.00 8.25 7.75 and convert them to this: 0.0725 0.0700 0.0825 0.0775 I am using Excel 2000 and have gone through all the format options but can't find anything that will do the trick. If someone could show me how to do this it would ge greatly appreciated. Thanks in advance, KP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting 2-place decimal value to floating point decimal number with leading zero
Hi!
Try this: This will convert then in-place. In an empty cell enter 100. Now select that cell and do EditCopy. Select the range of cells you want converted. Then EditPaste SpecialDivideOK Biff "Kermit Piper" wrote in message oups.com... Hello, I thought this would be simple, but, what I'm trying to do is take a column of numbers like this: 7.25 7.00 8.25 7.75 and convert them to this: 0.0725 0.0700 0.0825 0.0775 I am using Excel 2000 and have gone through all the format options but can't find anything that will do the trick. If someone could show me how to do this it would ge greatly appreciated. Thanks in advance, KP |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting 2-place decimal value to floating point decimal number with leading zero
Thanks all, great suggestions..and they work!!! :)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need if-then formula-If a number is > /< something, then place a . | Excel Worksheet Functions | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
cell that accepts a whole number or five place deciaml | Excel Worksheet Functions | |||
single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions |