Decimal place

[deanl33069]

Is it possible to format a cell to auto fill 2 decimal places on a number..
now if i type 1234 in cell B1 which is formatted for 2 decimal places it come out as
1234.00
i want
12.34
help

 

[shg]

File > Options > Advanced, tick Automatically insert a decimal place.

 

[deanl33069]

File > Options > Advanced, tick Automatically insert a decimal place.

Ty , But i only need column m to do it . this changes the whole sheet.

 

[shg]

That would require VBA.

 

[Scott Huish]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, d As Range
Set d = Intersect(Target, Range("M:M"))
If d Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each c In d
    If IsNumeric(c) And c <> "" Then c = c / 100: c.NumberFormat = "0.00"
Next
Application.EnableEvents = True
End Sub

Right click the tab for the sheet you want this to happen on.
Click on View Code.
Paste into white area.
Hit Alt-q
Save workbook as type .xlsm

 

[deanl33069]

TYVM Works GREAT