One of my collegue's excel has a weird problem. Whenever he types something
in excel and presses enter, ^ sign comes before the text or the number.
Because of this formulas dont work he has to edit the cell and delete this ^
sign to make it work.

What can be the issue?

I've seen this with text (not numbers).

Maybe you could try this:
tools|Options|Transition tab|Uncheck "Transition navigation keys"
(xl2003 menu system)

In fact, I'd uncheck all those Lotus 123 settings.

In old versions of Lotus 123, you could center your entry by typing that caret
(^abcd would center abcd in the cell).

Leading apostrophes 'abcd meant that it was left justified.
Leading backslash \abcd would fill the cell with that string


Gaurav wrote:

One of my collegue's excel has a weird problem. Whenever he types something
in excel and presses enter, ^ sign comes before the text or the number.
Because of this formulas dont work he has to edit the cell and delete this ^
sign to make it work.

What can be the issue?

--

Dave Peterson

Excell is set to behave like Lotus 1-2-3

Try this:
From the Excel Main Menu:
<tools<options<transition tab

UNcheck everything!
(especially Transition Navigation keys
....the probable culprit)

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Gaurav" wrote in message
...
One of my collegue's excel has a weird problem. Whenever he types
something in excel and presses enter, ^ sign comes before the text or the
number. Because of this formulas dont work he has to edit the cell and
delete this ^ sign to make it work.

What can be the issue?

ps. The cell would have to be formatted as Center for this to happen
automatically.

Dave Peterson wrote:

I've seen this with text (not numbers).

Maybe you could try this:
tools|Options|Transition tab|Uncheck "Transition navigation keys"
(xl2003 menu system)

In fact, I'd uncheck all those Lotus 123 settings.

In old versions of Lotus 123, you could center your entry by typing that caret
(^abcd would center abcd in the cell).

Leading apostrophes 'abcd meant that it was left justified.
Leading backslash \abcd would fill the cell with that string

Gaurav wrote:

One of my collegue's excel has a weird problem. Whenever he types something
in excel and presses enter, ^ sign comes before the text or the number.
Because of this formulas dont work he has to edit the cell and delete this ^
sign to make it work.

What can be the issue?

--

Dave Peterson

--

Dave Peterson

Thanks Dave and Ron.
It helped.

"Gaurav" wrote in message
...
One of my collegue's excel has a weird problem. Whenever he types
something in excel and presses enter, ^ sign comes before the text or the
number. Because of this formulas dont work he has to edit the cell and
delete this ^ sign to make it work.

What can be the issue?