Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stoping auto format
I have a spreadsheet that i use to fill out both text and numeric
information. I have formatted the cells in the text collumns to Text but every time i type in the letter i, it converts it to a capital. Is there any way of making it stop? I work in excel 2000 -- Thank you for reading my post. Hopefully you can answer my querie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
stoping auto format
If it's just a single i (i was here) then it's probably auto correct. Open
auto correct and delete the entry i I Mike "Shazza" wrote: I have a spreadsheet that i use to fill out both text and numeric information. I have formatted the cells in the text collumns to Text but every time i type in the letter i, it converts it to a capital. Is there any way of making it stop? I work in excel 2000 -- Thank you for reading my post. Hopefully you can answer my querie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
stoping auto format
Oh finally. thats brilliant thank you very much. I Feel a bit of a fool
that i never thought of that before hand but never mind. Cheers your a star "Mike H" wrote: If it's just a single i (i was here) then it's probably auto correct. Open auto correct and delete the entry i I Mike "Shazza" wrote: I have a spreadsheet that i use to fill out both text and numeric information. I have formatted the cells in the text collumns to Text but every time i type in the letter i, it converts it to a capital. Is there any way of making it stop? I work in excel 2000 -- Thank you for reading my post. Hopefully you can answer my querie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
stoping auto format
As Mike points out, this is an AutoCorrect feature.
Use Tools|AutoCorrect and delete that entry Be aware that is the latest version of Office, AutoCorrect entries are common to many apps (Word, Excel and - I believe- PowerPoint) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Shazza" wrote in message ... I have a spreadsheet that i use to fill out both text and numeric information. I have formatted the cells in the text collumns to Text but every time i type in the letter i, it converts it to a capital. Is there any way of making it stop? I work in excel 2000 -- Thank you for reading my post. Hopefully you can answer my querie |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
stoping auto format
Your welcome and thanks for the feedback.
Mike "Shazza" wrote: Oh finally. thats brilliant thank you very much. I Feel a bit of a fool that i never thought of that before hand but never mind. Cheers your a star "Mike H" wrote: If it's just a single i (i was here) then it's probably auto correct. Open auto correct and delete the entry i I Mike "Shazza" wrote: I have a spreadsheet that i use to fill out both text and numeric information. I have formatted the cells in the text collumns to Text but every time i type in the letter i, it converts it to a capital. Is there any way of making it stop? I work in excel 2000 -- Thank you for reading my post. Hopefully you can answer my querie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stoping the Macro Warning Message | Excel Discussion (Misc queries) | |||
stoping excel from automatic zoomig | Excel Discussion (Misc queries) | |||
Stoping IE from embedding xls sheets | Excel Discussion (Misc queries) | |||
Stoping users from saving tables to their local machines... | Excel Discussion (Misc queries) | |||
Stoping users pasting formulas into cells | Excel Worksheet Functions |