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
|
|||
|
|||
formatting problem with functions
I have attempted to use the PROPER function in an adjacent column to my data.
I entered =proper(e1) and the cell only display the function not the result. Help! |
#2
|
|||
|
|||
check to see if the cell is formated as text
or check toolsoptionsview and see if formulas is checked or select the equals sign and replace it with another equals sign (sometimes works) "Robin M." wrote: I have attempted to use the PROPER function in an adjacent column to my data. I entered =proper(e1) and the cell only display the function not the result. Help! |
#3
|
|||
|
|||
I'd tried all that. None of it works. Let me know if you have any more
ideas. Thanks. "bj" wrote: check to see if the cell is formated as text or check toolsoptionsview and see if formulas is checked or select the equals sign and replace it with another equals sign (sometimes works) "Robin M." wrote: I have attempted to use the PROPER function in an adjacent column to my data. I entered =proper(e1) and the cell only display the function not the result. Help! |
#4
|
|||
|
|||
Robin
Select the range and format to General. With reange selected, EditReplace what: = with: = Replace all. Gord Dibben Excel MVP On Thu, 6 Oct 2005 12:42:55 -0700, "Robin M." wrote: I'd tried all that. None of it works. Let me know if you have any more ideas. Thanks. "bj" wrote: check to see if the cell is formated as text or check toolsoptionsview and see if formulas is checked or select the equals sign and replace it with another equals sign (sometimes works) "Robin M." wrote: I have attempted to use the PROPER function in an adjacent column to my data. I entered =proper(e1) and the cell only display the function not the result. Help! |
#5
|
|||
|
|||
That worked! What an odd bug. Thanks Gord.
"Gord Dibben" wrote: Robin Select the range and format to General. With reange selected, EditReplace what: = with: = Replace all. Gord Dibben Excel MVP On Thu, 6 Oct 2005 12:42:55 -0700, "Robin M." wrote: I'd tried all that. None of it works. Let me know if you have any more ideas. Thanks. "bj" wrote: check to see if the cell is formated as text or check toolsoptionsview and see if formulas is checked or select the equals sign and replace it with another equals sign (sometimes works) "Robin M." wrote: I have attempted to use the PROPER function in an adjacent column to my data. I entered =proper(e1) and the cell only display the function not the result. Help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rec. Nav. problem cause by checkboxes/Conditional formatting | Shelbygt22 | General Discussion | 0 | March 22nd, 2005 04:59 PM |
Formatting problem in Query Design Grid | hlmcclean | General Discussion | 5 | January 17th, 2005 08:19 PM |
Conditional Formatting Problem | CJ | Using Forms | 0 | November 30th, 2004 06:02 AM |
Formatting problem with Word 2003 | K Narayana Moorthy | New Users | 4 | June 22nd, 2004 06:42 AM |
Excel formatting problem when pasting | Bill | Worksheet Functions | 2 | April 4th, 2004 12:34 PM |