There is no way to do this in just one column
You can have the whole worksheet behave that way with Tools|Options; open
the Edit tab and check the Fixed Decimals box and specify 2 decimal places
You could do this; enter your values and then uncheck the box.

or if it is a one-off affair:
enter the numbers with out decimals
type 100 in an empty cell
copy the cell
select the numbers to be 'fixed'; use Edit Paste Special-specify Divide
now you can delete the 100

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jannie" wrote in message
...
I have a worksheet with 3 columns. Some numbers are like. 2450.00. Some are
7.47 and some are 125.69. I have the columns formatted for 2 places. Is
there
anyway to simply enter a number in a specific column and not have to enter
the decimal while entering the number and have it automatically make it 2
decimal places.

Example when I enter 2450 it formats the number 2450.00 which is perfect -
that is what I want it to do. But, if I enter 7.47 I have to enter the
decimal or else it formats 747.00. Is there anyway to make that column
format
7.47?
Jannie