Numbers? automatic

  • Thread starter Thread starter CMarkou
  • Start date Start date
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
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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)
 
Thanks Norman
Appreciate the help. Any way to get digit to show up in front of th
decimal with out typing it
 
Back
Top