Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Proper function not updating in cells
I've found that the Proper text function sometimes does not update the text
that is the object of the function...it simply leaves "=PROPER(C6)" displayed in the cells. Could it be the formatting of the original cells, the cells in which I have placed the function, or is something else going on? It seems to do this when it pleases...sometimes it works, sometimes it doesn't. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Proper function not updating in cells
If the original cell (C6) is formatted as Text, then Excel will apply
the same format to the cell with the formula in - just format it as General. Hope this helps. Pete On Sep 19, 3:34 pm, Richard Champlin wrote: I've found that the Proper text function sometimes does not update the text that is the object of the function...it simply leaves "=PROPER(C6)" displayed in the cells. Could it be the formatting of the original cells, the cells in which I have placed the function, or is something else going on? It seems to do this when it pleases...sometimes it works, sometimes it doesn't. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Proper function not updating in cells
There are three reasons a cell would show the formula rather than the result:
1. the cell was formatted as Text prior to the formula being entered 2. the keystrokes CNTRL-` had been touched (this can be toggled) 3. the fomula starts with a single quote (apostrophe) If 2 were the case, then ALL cells would display formulae rather than results. if 3 were the case, then you would see the single quote in the formula bar. Just insure that all cells into which you intend to type formulae have not been formatted as text. -- Gary''s Student - gsnu200745 "Richard Champlin" wrote: I've found that the Proper text function sometimes does not update the text that is the object of the function...it simply leaves "=PROPER(C6)" displayed in the cells. Could it be the formatting of the original cells, the cells in which I have placed the function, or is something else going on? It seems to do this when it pleases...sometimes it works, sometimes it doesn't. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROPER FUNCTION | Excel Worksheet Functions | |||
Help w/ the PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Discussion (Misc queries) |