Hitchhikers guide to the Galaxy...?????

[Tansy]

Sure theres a simple answer to this one! got a user on
Excel 97. Every time he types in the number 56 in a
spreadsheet it turns into number 43 .... can't replicate
it on my machine I'm on Excel 2000..............any ideas??

many thanks, a virtual chocolate bar, or beer to anyone
who knows the answer!

T

 

[Mike Middleton]

Tansy -

Sure theres a simple answer to this one! got a user on Excel 97. Every

time he types in the number 56 in a spreadsheet it turns into number 43
..... can't replicate it on my machine I'm on Excel 2000 .............. any
ideas??<

Tools | Autocorrect ...

- Mike Middleton, www.usfca.edu/~middleton

 

[Ken Wright]

One of the best ways to wind someone up. That and Tools / Options / International Tab / View
Current Sheet -> Right To Left.

 

[Norman Harker]

Hi Tansy!

Tools > AutoCorrect Options

Find the 56 that autocorrects to 43
Either:
Select the entry and Delete the entry
OK

Or:
Select Entry and edit to the correct answer which is 42.
OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Belgium (Flemish Community Holiday and Guldensporenslag); France (La
Fete de la Magdalene); International (World Population Day); Italy
(St. Rosalia Day); Mongolia (Revolution Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ken Wright]

LOL

 

[Norman Harker]

Hi Ken!

Function LIFE()
LIFE = 42
End Function

Much better. Less confusing!

Regards


Arthur Dent