| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing to Proper Case
I have merged 2 worksheets into Excel 2003, I cannot get the formula to
change to "Proper Case", I know how to do it on a new worsheet, but for some reason, I cannot get it to work on this combined one. Is it maybe protected, or locked or have a conditional formatting to it? I can't figure it out, and cannot find an answer via the website. Thanks in advance. -- Susan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing to Proper Case
Select All ..Clear..formats and then try
-- If this post helps click Yes --------------- Jacob Skaria "Susan Nauceder" wrote: I have merged 2 worksheets into Excel 2003, I cannot get the formula to change to "Proper Case", I know how to do it on a new worsheet, but for some reason, I cannot get it to work on this combined one. Is it maybe protected, or locked or have a conditional formatting to it? I can't figure it out, and cannot find an answer via the website. Thanks in advance. -- Susan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing to Proper Case
No, it still just has the formula showing in the box, not the results. Any
more ideas, please? -- Susan "Jacob Skaria" wrote: Select All ..Clear..formats and then try -- If this post helps click Yes --------------- Jacob Skaria "Susan Nauceder" wrote: I have merged 2 worksheets into Excel 2003, I cannot get the formula to change to "Proper Case", I know how to do it on a new worsheet, but for some reason, I cannot get it to work on this combined one. Is it maybe protected, or locked or have a conditional formatting to it? I can't figure it out, and cannot find an answer via the website. Thanks in advance. -- Susan |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing to Proper Case
I think i've got it, thank you soooo much for your help.
-- Susan "Jacob Skaria" wrote: Select All ..Clear..formats and then try -- If this post helps click Yes --------------- Jacob Skaria "Susan Nauceder" wrote: I have merged 2 worksheets into Excel 2003, I cannot get the formula to change to "Proper Case", I know how to do it on a new worsheet, but for some reason, I cannot get it to work on this combined one. Is it maybe protected, or locked or have a conditional formatting to it? I can't figure it out, and cannot find an answer via the website. Thanks in advance. -- Susan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing to Proper Case | Excel Discussion (Misc queries) | |||
| Changing a whole spreadsheet to proper case | Excel Discussion (Misc queries) | |||
| Changing Entries to Proper and Upper Case Q | Excel Worksheet Functions | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
| Changing Upper case to Proper Case | Excel Worksheet Functions | |||
Linear Mode
