Taxi Meter dollars to miles driven per trip

[Ralphnet]

Meter Dist.

24.60 1.1E+01
45.00 1.1E+01


5.80 2.0E+00 This is right but I don't need the E+00 and it dosen't work if I e
5.80 2.0E+00 enter amounts that aren't in .20's ?

 

[Oaktree]

Your question is not clear.

What are you trying to do? Is there a formula somewhere? Is this just a formatting issue where you don't want the result of your formula formatted as scientific?

Please rephrase your question.

 

[NBVC]

Ralphnet,

If you want people to understand your questions and to better assist you , it would be nice if you stuck to your original post:

http://www.mrexcel.com/board2/viewtopic.php?t=181518&highlight=


It looks like you have your cell formatted in Scientific. If you don't want that, then change cell format to General or Number and specificy number of decimals. Go to Format|Cells and select the Number tab. Then select the Number Category and enter the number of decimal places.