If you type an @ symbol at the beginning of a cell it behaves in a similar
way to typing =. Indeed, it gets changed to = once you hit enter. Is it just
a synonym for = or does it do something else? Why is it not documented? I'm
getting errors loading data into excel programatically and I suspect its
because of a leading @ sign.

Check in the Tools Menu - Auto Correct.
You may have it setup to replace the @ with an =

The @ doesn't behave the same as an equal on my PC.

"rod" wrote:

If you type an @ symbol at the beginning of a cell it behaves in a similar
way to typing =. Indeed, it gets changed to = once you hit enter. Is it just
a synonym for = or does it do something else? Why is it not documented? I'm
getting errors loading data into excel programatically and I suspect its
because of a leading @ sign.

The @ is a carry over from the old Lotus 123 days. The @ was the key to
start a formula. For example in Lotus 123 you would type @sum ( ) and in
excel you can type =sum ( ) or @sum( ) and get the same results.

"Joel" wrote:

Check in the Tools Menu - Auto Correct.
You may have it setup to replace the @ with an =

The @ doesn't behave the same as an equal on my PC.

"rod" wrote:

If you type an @ symbol at the beginning of a cell it behaves in a similar
way to typing =. Indeed, it gets changed to = once you hit enter. Is it just
a synonym for = or does it do something else? Why is it not documented? I'm
getting errors loading data into excel programatically and I suspect its
because of a leading @ sign.

Lotus 123 uses @ as the function indicator: @sum(), @if().

Because excel wants to make it easy for Lotus 123 users to switch to excel, they
let you use @ when you enter the formula.



rod wrote:

If you type an @ symbol at the beginning of a cell it behaves in a similar
way to typing =. Indeed, it gets changed to = once you hit enter. Is it just
a synonym for = or does it do something else? Why is it not documented? I'm
getting errors loading data into excel programatically and I suspect its
because of a leading @ sign.

--

Dave Peterson

Thanks guys. I did finally find a help page in Excel about this "Differences
between Microsoft Excel and Lotus 1-2-3" but you needed to know it was a 123
issue. Not helped by the fact that you can't search for @ - well you can but
it doesn't find anything (even in this discussion group).

"Dave Peterson" wrote:

Lotus 123 uses @ as the function indicator: @sum(), @if().

Because excel wants to make it easy for Lotus 123 users to switch to excel, they
let you use @ when you enter the formula.



rod wrote:

If you type an @ symbol at the beginning of a cell it behaves in a similar
way to typing =. Indeed, it gets changed to = once you hit enter. Is it just
a synonym for = or does it do something else? Why is it not documented? I'm
getting errors loading data into excel programatically and I suspect its
because of a leading @ sign.

--

Dave Peterson

If your search for @ was successful, it probably wouldn't help. Every message
with an email address would be returned!

But glad you found the reason.

rod wrote:

Thanks guys. I did finally find a help page in Excel about this "Differences
between Microsoft Excel and Lotus 1-2-3" but you needed to know it was a 123
issue. Not helped by the fact that you can't search for @ - well you can but
it doesn't find anything (even in this discussion group).

"Dave Peterson" wrote:

Lotus 123 uses @ as the function indicator: @sum(), @if().

Because excel wants to make it easy for Lotus 123 users to switch to excel, they
let you use @ when you enter the formula.



rod wrote:

If you type an @ symbol at the beginning of a cell it behaves in a similar
way to typing =. Indeed, it gets changed to = once you hit enter. Is it just
a synonym for = or does it do something else? Why is it not documented? I'm
getting errors loading data into excel programatically and I suspect its
because of a leading @ sign.

--

Dave Peterson


--

Dave Peterson

Confirmation: If you have reserved a seat to continue your flight in China,
or for a return journey on an international or regional flight, you should
reconfirm its reservation at least 72 hours before departure if you'll stop
over at the boarding place for longer than 72 hours. Or else the seat shall
be automatically cancelled. No confirmation is necessary if you stop over at
the place for your continued flight or return flight for less than 72
hours.Ticket Validity: The validity period of normal fare tickets, whether
for single, return or circular trips, is one year. The validity periods of
special fare tickets and discount normal fare tickets are calculated on the
basis of related fares in accordance with relevant stipulations.
http://mytravel-log.blogspot.com/