| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
capitalize first letter automatically
i tried tools menue- autocorrect options - autocorrect - captalize first
letter.. but it didn't work |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
capitalize first letter automatically
The option is "Capitalize first letter of sentences". Excel doesn't have
a concept of "sentences". raft wrote: i tried tools menue- autocorrect options - autocorrect - captalize first letter.. but it didn't work |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
capitalize first letter automatically
But it will capitalize the first word after a full stop.
Type qwerty. asdfgh and Excel will change it to qwerty. Asdfgh Strange doin's Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 08:46:56 -0500, Bob I wrote: The option is "Capitalize first letter of sentences". Excel doesn't have a concept of "sentences". raft wrote: i tried tools menue- autocorrect options - autocorrect - captalize first letter.. but it didn't work |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
capitalize first letter automatically
Solved. It simply capitalizes the first character after a ". " (period
space combo. Still doesn't know what a "sentence" is. ;-) Gord Dibben wrote: But it will capitalize the first word after a full stop. Type qwerty. asdfgh and Excel will change it to qwerty. Asdfgh Strange doin's Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 08:46:56 -0500, Bob I wrote: The option is "Capitalize first letter of sentences". Excel doesn't have a concept of "sentences". raft wrote: i tried tools menue- autocorrect options - autocorrect - captalize first letter.. but it didn't work |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
capitalize first letter automatically
Thanks Bob.
I tested with .qwerty but not with .<spaceqwerty. Live and learn. Gord On Wed, 30 Apr 2008 16:55:56 -0500, Bob I wrote: Solved. It simply capitalizes the first character after a ". " (period space combo. Still doesn't know what a "sentence" is. ;-) Gord Dibben wrote: But it will capitalize the first word after a full stop. Type qwerty. asdfgh and Excel will change it to qwerty. Asdfgh Strange doin's Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 08:46:56 -0500, Bob I wrote: The option is "Capitalize first letter of sentences". Excel doesn't have a concept of "sentences". raft wrote: i tried tools menue- autocorrect options - autocorrect - captalize first letter.. but it didn't work |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
capitalize first letter automatically
NP, just knew had to be some kind of logic behind the behavior one observes.
Gord Dibben wrote: Thanks Bob. I tested with .qwerty but not with .<spaceqwerty. Live and learn. Gord On Wed, 30 Apr 2008 16:55:56 -0500, Bob I wrote: Solved. It simply capitalizes the first character after a ". " (period space combo. Still doesn't know what a "sentence" is. ;-) Gord Dibben wrote: But it will capitalize the first word after a full stop. Type qwerty. asdfgh and Excel will change it to qwerty. Asdfgh Strange doin's Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 08:46:56 -0500, Bob I wrote: The option is "Capitalize first letter of sentences". Excel doesn't have a concept of "sentences". raft wrote: i tried tools menue- autocorrect options - autocorrect - captalize first letter.. but it didn't work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I capitalize the first letter of multiple cells? | Excel Discussion (Misc queries) | |||
| capitalize first letter automatically when typing in excel cell | Excel Discussion (Misc queries) | |||
| Capitalize first letter in sentence | Excel Worksheet Functions | |||
| make a letter in a cell automatically equal a dollar amount | Excel Discussion (Misc queries) | |||
| Capitalize first letter when type a name in each cell. | Excel Worksheet Functions | |||
Linear Mode
