Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
@
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
@
@ 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 |
Display Modes | |
|
|