#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default @

I'm using Excel 2002 SP3 on a Win2K Machine.

I found a curious error message while typing some short-hand notes into a
cell. Does the symbol "@" carry some significance in Excel?

For example, the statement produced the error message was:
@ the

The error message was the one about "The formula you typed contains an
error." . . .

Is this a bug or does "@" have some significance?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default @

@ is how Lotus 1-2-3 formulas start and Excel graciously assumes you're a
convert if you use it. You can work around this by either starting with an
apostrophe (which does not appear in the cell) or format the cell with the
Text number format.

--
Jim
"dfunk" wrote in message
...
I'm using Excel 2002 SP3 on a Win2K Machine.

I found a curious error message while typing some short-hand notes into a
cell. Does the symbol "@" carry some significance in Excel?

For example, the statement produced the error message was:
@ the

The error message was the one about "The formula you typed contains an
error." . . .

Is this a bug or does "@" have some significance?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"