Hi,

If you do not want to use a macro, you can type 100 in any cell and then
copy this value of 100. After doing so, select the column for gallons and
then Edit Paste Special Divide

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Brenda" wrote in message
...
I have an Excel 2007 spreadsheet for mileage & fuel gallons on the same
worksheet.
Mileage is formatted as a whole number. Fuel gallons I want formatted
with
2 decimal places. I do not want to enter the decimal point. I can set
the
worksheet to "automatic insert a decimal point" to 2 places, but it
overides
the format for the mileage as a whole number. If I turn off "automatic
insert a decimal point", I have to manually insert a decimal point.

Ex:
Mileage Gallons

Driver 3500 Truck 1 125.12

Any suggestions?

--
Brenda