Brenda
You can use a small macro applicable to only that one column, that would
place the decimal point for you whenever you enter a number. You would
format that column as General. However, the number of decimal places you
want for each and every number would have to be the same. For instance, if
you want to enter 15 gallons, you would have to type 1500. If you type 15
you would get ".15". In other words, the macro would simply place the
decimal point between the second and third characters from the right. Would
that work for you? HTH Otto
"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