LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rod Rod is offline
external usenet poster
 
Posts: 108
Default What does the @ symbol do?

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



 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
what shortcut key do I use for the + symbol over the - symbol cherokee Excel Discussion (Misc queries) 5 July 14th 06 12:43 AM
$ Symbol Big Rick Excel Discussion (Misc queries) 3 September 20th 05 06:56 PM
How can you get a yen symbol? EH Excel Worksheet Functions 1 August 10th 05 03:03 PM
I need a symbol but "symbol" in the Insert menu is grayed-out. Nothappy Excel Discussion (Misc queries) 2 May 3rd 05 12:16 AM
Between Symbol chard9401 Excel Worksheet Functions 2 November 11th 04 06:40 PM


All times are GMT +1. The time now is 04:37 PM.

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

About Us

"It's about Microsoft Excel"