Home |
Search |
Today's Posts |
#1
|
|||
|
|||
what is ! in a formula converted from lotus 123
I have converted spreadsheets from lotus 123 into excel 2000 and in some of
the formulas a exclamation mark ! symbol appears in the middle of the figures. No one seems to know what this means or doing if anything, Can you please help me. Regards Chef |
#2
|
|||
|
|||
Hi
if it looks like this Sheet2!A1 it means that you're talking about cell A1 on Sheet 2 rather than on the current sheet -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "chefbayliss" wrote in message ... I have converted spreadsheets from lotus 123 into excel 2000 and in some of the formulas a exclamation mark ! symbol appears in the middle of the figures. No one seems to know what this means or doing if anything, Can you please help me. Regards Chef |
#3
|
|||
|
|||
Can you give us an example?
"chefbayliss" wrote: I have converted spreadsheets from lotus 123 into excel 2000 and in some of the formulas a exclamation mark ! symbol appears in the middle of the figures. No one seems to know what this means or doing if anything, Can you please help me. Regards Chef |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |