Private Sub Worksheet_Activate()
Application.FixedDecimal = True
End Sub

Private Sub Worksheet_Deactivate()
Application.FixedDecimal = False
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Charlotte" wrote in message
...
I know how to do fixed decimals thru the tools option on the menu, but is
there a way for it to be worksheet specifi? I don't want all my worksheet
to
be fixed, just certain ones. Can anyone help?
--
Charlotte