Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 18th 06, 07:43 AM posted to microsoft.public.excel.misc
Kermit Piper
 
Posts: n/a
Default 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   Report Post  
Old March 18th 06, 08:31 AM posted to microsoft.public.excel.misc
R..VENKATARAMAN
 
Posts: n/a
Default 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   Report Post  
Old March 18th 06, 08:34 AM posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default 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   Report Post  
Old March 18th 06, 07:20 PM posted to microsoft.public.excel.misc
Kermit Piper
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need if-then formula-If a number is > /< something, then place a . JDenio Excel Worksheet Functions 3 March 24th 05 09:29 PM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 07:07 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 06:29 PM
cell that accepts a whole number or five place deciaml crck_whr Excel Worksheet Functions 2 November 12th 04 05:14 PM
single quote 10-digit number that has leading zeroes & then conca. lorelei739 Excel Worksheet Functions 1 November 5th 04 01:02 AM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017