| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
State abbrev. TN changes to ten can not type TN as abbre.
When I type the abbreiation for Tenn (TN) excel overridge and I get ten. I
don't have any provblems with any of the other states only TN. How can I over ride this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
State abbrev. TN changes to ten can not type TN as abbre.
teresac wrote:
When I type the abbreiation for Tenn (TN) excel overridge and I get ten. I don't have any provblems with any of the other states only TN. How can I over ride this. Look at "Troubleshoot automatic corrections" in the help file. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
State abbrev. TN changes to ten can not type TN as abbre.
Click on TOOLS Autocorrect Options Scroll through the listing of autocorrections and find the one for TN, delete it. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46754 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
State abbrev. TN changes to ten can not type TN as abbre.
Hi,
check your auto correct options on the Tools menu, and delete the one for TN. -- If this helps, please click the Yes button Cheers, Shane Devenshire "teresac" wrote: When I type the abbreiation for Tenn (TN) excel overridge and I get ten. I don't have any provblems with any of the other states only TN. How can I over ride this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Hybrid Mode
