Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Column title automatically changes?
I am trying to label a column "ppm" (for parts per million) and as soon as I
enter ppm, Excel automatically changes it to "pap". I have formated the cell for text, general, and number, and that does not help. What is going on? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Column title automatically changes?
Sounds like you've got an entry in your AutoCorrect Options to change "ppm"
to "pap". In Excel 2007: Click on the Office Button (Big Circle in upper-left corner) Click the "Excel Options" Button Select the "Proofing Tab" on the left Click the "AutoCorrect Options" Button Check to see if "ppm" is on the Replace List Delete that entry if you find it In Excel 2003 or older: Goto the TOOLS Menu Select "AutoCorrect Options" Check to see if "ppm" is on the Replace List Delete that entry if you find it HTH Elkar "Zinger" wrote: I am trying to label a column "ppm" (for parts per million) and as soon as I enter ppm, Excel automatically changes it to "pap". I have formated the cell for text, general, and number, and that does not help. What is going on? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Column title automatically changes?
Thank you Elkar! That was exactly the problem.
"Elkar" wrote: Sounds like you've got an entry in your AutoCorrect Options to change "ppm" to "pap". In Excel 2007: Click on the Office Button (Big Circle in upper-left corner) Click the "Excel Options" Button Select the "Proofing Tab" on the left Click the "AutoCorrect Options" Button Check to see if "ppm" is on the Replace List Delete that entry if you find it In Excel 2003 or older: Goto the TOOLS Menu Select "AutoCorrect Options" Check to see if "ppm" is on the Replace List Delete that entry if you find it HTH Elkar "Zinger" wrote: I am trying to label a column "ppm" (for parts per million) and as soon as I enter ppm, Excel automatically changes it to "pap". I have formated the cell for text, general, and number, and that does not help. What is going on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically insert salary based on job title | Excel Worksheet Functions | |||
Column Title changes | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Sumif based on column A and title of another column | Excel Discussion (Misc queries) | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) |