! in Calculations

Can anyone explain to me what the ! is used for when your calculation is
puling data from another worksheet.
e.g. =+"sheet1'!B3

Thanks Strata

"Strata" <[email protected]> wrote in message
news:[email protected]...
> Can anyone explain to me what the ! is used for when your calculation is
> puling data from another worksheet.
> e.g. =+"sheet1'!B3
>
> Thanks Strata

The ! is just used as a separator token.
/Fredrik

And the + is not needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Strata" <[email protected]> wrote in message
news:[email protected]...
> Can anyone explain to me what the ! is used for when your calculation is
> puling data from another worksheet.
> e.g. =+"sheet1'!B3
>
> Thanks Strata

sorry "data" not "date"


--
JackPosted from - http://www.officehelp.in

Can Anyone help with setting up a league table in excel (for Mac) I have
a four team round robin, I want to enter scores and for the now blank
league tables to interpret date and fill out the coloumns Played, won,
drawn, goals for, goals against and points - Even if some knows the
technical term in excel for this i would appreciate it. Apologies If I
have posted this in the wrong area.

Jack


--
JackPosted from - http://www.officehelp.in