Rose wrote:
I am a new user of excel. I'd like to set a column so the entry sets a
decimel point for a money entry. I'd like to enter 12345 and have it show up
as 123.45

I'd really appreciate it if the instructions were step-by-step.

Thanks.

From the help file searching on floating decimal point:


Specify a fixed decimal point for numbers
On the Tools menu, click Options.
On the Edit tab, select the Fixed decimal check box.
In the Places box, enter a positive number for digits to the right of the
decimal point or a negative number for digits to the left of the decimal point.
For example, if you enter 3 in the Places box and then type 2834 in a cell,
the value will be 2.834. If you enter -3 in the Places box and then type
283 in a cell, the value will be 283000.

Click OK.
The FIX indicator appears in the status bar.

On the worksheet, click a cell, and then type the number that you want.
Note The data that you typed before you selected the Fixed decimal check
box is not affected.

Tips
To temporarily override the fixed decimal option, type a decimal point when
you type the number.
To remove decimal points from numbers that you already entered with fixed
decimals:
On the Edit tab of the Options dialog box, clear the Fixed decimal check box.
In an empty cell, type a number such as 10, 100, or 1,000, depending on the
number of decimal places that you want to remove.
For example, type 100 in the cell if the numbers contain two decimal places
and you want to convert them to whole numbers.

Click Copy (or press CTRL+C) to copy the cell to the Clipboard, and then
select the cells that contain the numbers with decimal places.
On the Edit menu, click Paste Special, and then click Multiply.

gls858