setting a floating decimel point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If you want all values to work that way, choose Tools/Options/Edit and
check the Fixed decimal places, and enter 2 in the box.

I you want just the one column, right-click the worksheet tab and choose
View Code. Paste this into the window that opens:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Cells.Count > 1 Then Exit Sub
If Not Intersect(.Cells, Range("A:A")) Is Nothing Then
If IsNumeric(.Value) Then
Application.EnableEvents = False
.Value = .Value / 100
Application.EnableEvents = True
End If
End If
End With
End Sub
 
Rose said:
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.
Click to expand...

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
 
Back
Top