Ron,

Thanks for your reply. I am using Excel 2007 and cannot find the area I
need to be in.

Beverly

"Ron Coderre" wrote:

It sounds like you have Formula Display turned on...

From the Excel Main Menu:
<tools<options<view tab
UNcheck: Formulas

or...for the keyboard shortcut...
Ctrl+~......The tilde "~" is the key above the Tab key.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Beverly" wrote in message
...
I am trying to sort only the left 6 characters of a column. I could not
find
where I could select and sort only the first 6 characters so I created
another column 'B' and used the B1=LEFT(A1,6). I used the formula box to
verify format and the result was correct, but when I hit enter only ths
function showed in the cell B1. What am I doing wrong? It's driving me
crazy!