If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"proper" function excel wksht
Why would the "proper" funtion for capitalizing work on some columns of my
worksheet and not on others. Some display the proper Capitalized text, other columns just display the formula. Using same formula in both places. |
#2
|
|||
|
|||
The cells the formula are in are formatted as text
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "CajnBred" wrote in message ... Why would the "proper" funtion for capitalizing work on some columns of my worksheet and not on others. Some display the proper Capitalized text, other columns just display the formula. Using same formula in both places. |
#3
|
|||
|
|||
Most likely cause is that the "some" columns were pre-formatted as text which
will make the formulas text. Select one of these and F2 then ENTER to see if results change. If you have many of these to do use EditReplace. Select all cells and EditReplace What: = With: = This coerces the text to real formulas. Gord Dibben Excel MVP On Tue, 12 Apr 2005 14:58:02 -0700, "CajnBred" wrote: Why would the "proper" funtion for capitalizing work on some columns of my worksheet and not on others. Some display the proper Capitalized text, other columns just display the formula. Using same formula in both places. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CONVERT Function Disappered in Excel | Gord Dibben | General Discussion | 3 | April 13th, 2005 07:59 PM |
How to enable Excel print function ? | CK | Setting up and Configuration | 3 | February 22nd, 2005 06:41 PM |
CHR() function not working in Excel 2003 | Richard Jonas | General Discussion | 4 | February 16th, 2005 08:45 AM |
Function Keys in Excel | LPS | General Discussion | 2 | January 29th, 2005 12:32 AM |
Excel should have a quick and simple "change case" function like . | NinaSvendsen | Worksheet Functions | 1 | January 28th, 2005 03:15 PM |