| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change all cells to Proper text in Excel
I have followed previous postings but I am getting Circular reference errors
when I try to perform the fucntion on the cell I am trying to change. |
|
#2
|
|||
|
|||
|
You have to place the formula in a different cell. For example if the text
"PrOper TeXt" was in A1 and you placed the formula =PROPER(A1) into B1, B1 would have the value "Proper Text" -- Regards, Dave "Bruce" wrote: I have followed previous postings but I am getting Circular reference errors when I try to perform the fucntion on the cell I am trying to change. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
| Can I program Excel cells to change colour at a set date? | Excel Discussion (Misc queries) | |||
| Excel should allow me to change text color & font within tabs. | Excel Discussion (Misc queries) | |||
| How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
Linear Mode
