Home |
Search |
Today's Posts |
#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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value with using Excel function | New Users to Excel | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) |