Stephen, Thanks for the quick reply. Could we modify the
following Auto_Open Sub to automatically make auto percent
entry setting?

Sub Auto_Open()

'This code puts the cursor in cell A1 in all worksheets,
'and opens the workbook on the "Scorecard" worksheet.
'It also operates when worksheets are hidden.

Application.ScreenUpdating = False

For Each ws In Worksheets
If ws.Visible = xlSheetVisible Then
ws.Select
Application.GoTo ws.Range("A1"), True
ActiveWindow.DisplayGridlines = False
End If
Next

Worksheets("Scorecard").Select

Application.ScreenUpdating = True

End Sub



-----Original Message-----
Hi Phil,

In Excel 2000, I have created a worksheet for use on a
network. Certain cells (formatted percentage) have
data
values that create an area chart. On my screen, I
enter "75" in the source cell: "75%" shows on screen,
and
the chart plots a value at 75% (scale maximum is
100%).
However, other users have to enter ".75" to make things
work right.

Is there a way to have users enter a whole number, vs a
decimal?

Tools Options Edit Enable automatic percent entry

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

.