error message - no clue what it is about
 

When I use tools-- options--- edit tab in MS excel it gives an error:
The number must be between 1 and 32767. Try again by entering a number in
that range.

I have no numbers out of this.. What could be the reason for this error?

error message - no clue what it is about
 

I would say, select fixed decimal places, enter the number 2 in the box and
then de-select the option

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"smritisuman" wrote in message
...
When I use tools-- options--- edit tab in MS excel it gives an error:
The number must be between 1 and 32767. Try again by entering a number in
that range.

I have no numbers out of this.. What could be the reason for this error?