Numbers? automatic

C

CMarkou

I would like to know is there a way to get excel to automatically put
the decimal at the second position without having to type the point in?
Example I want to type 149 and would like it to read 1.49 Also is
there a way to get it to automatically put the first digit in? As
everything I type into these cells always starts with 1. Can it be
typed in as 49 or.49 and show up as 1.49?

Thanks
Chris
 
B

Bernard V Liengme

Use Tools|Options; open the Edit tab and locate Fixed Decimals
Be warned: this is a sticky setting and will apply to all workbooks you
open.
The newsgroup gets many questions about 'strange behaviour' - "I type 123
and get 1.23, why?"
So turned it off as soon as it is not needed.
Bernard
 
N

Norman Harker

Hi CMarkou!

Try:

Tools > Options > Edit
Check fixed decimal places.

Don't forget to undo this setting especially if someone else uses the
computer. We get a lot of requests for how to stop this.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
B

Bob Phillips

Chris,

Norman gave you a solution to one part. If you want it to do both parts, you
need VBA. This code goes into the worksheet code module

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False
On Error GoTo ws_exit
With Target
If IsNumeric(.Value) Then
.Value = 1 + .Value / 10 ^ (Len(.Value))
End If
End With

ws_exit:

Application.EnableEvents = True
End Sub

Don't check the decimal places as Norman suggested ikf you go for this
solution

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

CMarkou

Thanks Norman
Appreciate the help. Any way to get digit to show up in front of th
decimal with out typing it
 
Top