Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set default for a column so that first letters are caps?
if a column is names, how do i set it so that the first letters are all caps?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set default for a column so that first letters are caps?
Hi Theo
No setting available to force what you want, unless you use an event in VBA solution. You can apply solution after the data is entered, by using a helper column. With original data in A1, in another column enter =PROPER(A1) and copy down the column as far as required. Then, copy the whole of the helper column and Paste SpecialValues back over the data entered in column A. The helper column can then be deleted. -- Regards Roger Govier "theo" wrote in message ... if a column is names, how do i set it so that the first letters are all caps? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set default for a column so that first letters are caps?
Hi Theo,
For macro solutions to change in place when the macro is invoked or for an event macro to change when a constant is entered in a column(s) see http://www.mvps.org/dmcritchie/excel/proper.htm Microsoft Word offers a formatting option, Excel does not. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Roger Govier" wrote No setting available to force what you want, unless you use an event in VBA solution. You can apply solution after the data is entered, by using a helper column. With original data in A1, in another column enter =PROPER(A1) and copy down the column as far as required. Then, copy the whole of the helper column and Paste SpecialValues back over the data entered in column A. The helper column can then be deleted. "theo" wrote in message ... if a column is names, how do i set it so that the first letters are all caps? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the Column Headers back to letters from #s | Excel Discussion (Misc queries) | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions |