If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"30" in a cell becomes "50"
When I type in 30 or use 30 in an equation, Excel automatically reads it as
50 and displays it as 50. The keyboard has been changed a couple of times. This also happens in Word. Office has been removed and re-installed to no avail. Any idea as to why or how to fix it? |
#2
|
|||
|
|||
Hi
have you checked 'Tools - autocorrection'? -- Regards Frank Kabel Frankfurt, Germany Melanie wrote: When I type in 30 or use 30 in an equation, Excel automatically reads it as 50 and displays it as 50. The keyboard has been changed a couple of times. This also happens in Word. Office has been removed and re-installed to no avail. Any idea as to why or how to fix it? |
#3
|
|||
|
|||
THAT'S IT! Thank you, Frank! I can't imagine how that got set in 3
different Office applications, but it was. Thank you so much!! Melanie "Frank Kabel" wrote: Hi have you checked 'Tools - autocorrection'? -- Regards Frank Kabel Frankfurt, Germany Melanie wrote: When I type in 30 or use 30 in an equation, Excel automatically reads it as 50 and displays it as 50. The keyboard has been changed a couple of times. This also happens in Word. Office has been removed and re-installed to no avail. Any idea as to why or how to fix it? |
#4
|
|||
|
|||
The same AutoCorrect list is used for all the Office applications.
Melanie wrote: THAT'S IT! Thank you, Frank! I can't imagine how that got set in 3 different Office applications, but it was. Thank you so much!! Melanie "Frank Kabel" wrote: Hi have you checked 'Tools - autocorrection'? -- Regards Frank Kabel Frankfurt, Germany Melanie wrote: When I type in 30 or use 30 in an equation, Excel automatically reads it as 50 and displays it as 50. The keyboard has been changed a couple of times. This also happens in Word. Office has been removed and re-installed to no avail. Any idea as to why or how to fix it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
I see. Well, our IT guy just re-installed all of Office this morning, so
there must be some glitch in the CD. In any event, thank you both for your replies! Melanie "Debra Dalgleish" wrote: The same AutoCorrect list is used for all the Office applications. Melanie wrote: THAT'S IT! Thank you, Frank! I can't imagine how that got set in 3 different Office applications, but it was. Thank you so much!! Melanie "Frank Kabel" wrote: Hi have you checked 'Tools - autocorrection'? -- Regards Frank Kabel Frankfurt, Germany Melanie wrote: When I type in 30 or use 30 in an equation, Excel automatically reads it as 50 and displays it as 50. The keyboard has been changed a couple of times. This also happens in Word. Office has been removed and re-installed to no avail. Any idea as to why or how to fix it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
Probably not. This Autocorrect stuff is kept in a file named *.ACL. My bet is
that this file isn't touched by a reinstall. It would be a problem with most people if it were deleted during the reinstall--imagine if you had 1000's of words that were autocorrected! Melanie wrote: I see. Well, our IT guy just re-installed all of Office this morning, so there must be some glitch in the CD. In any event, thank you both for your replies! Melanie "Debra Dalgleish" wrote: The same AutoCorrect list is used for all the Office applications. Melanie wrote: THAT'S IT! Thank you, Frank! I can't imagine how that got set in 3 different Office applications, but it was. Thank you so much!! Melanie "Frank Kabel" wrote: Hi have you checked 'Tools - autocorrection'? -- Regards Frank Kabel Frankfurt, Germany Melanie wrote: When I type in 30 or use 30 in an equation, Excel automatically reads it as 50 and displays it as 50. The keyboard has been changed a couple of times. This also happens in Word. Office has been removed and re-installed to no avail. Any idea as to why or how to fix it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I conditionally UNLOCK a cell? | Chris | Worksheet Functions | 1 | August 31st, 2004 07:47 PM |
Looks Like a Pivot Table But Isn't... | MCorrea | Worksheet Functions | 3 | June 9th, 2004 10:47 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |