No need to use = sign in formulas
 

A friend has an Excel workbook that does not require the use of the = sign to
begin a formula. In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula without an = sign being
entered into the cell. However after the formula has been entered, the =
sign is placed automatically into the cell.

This workbook is at least 10 years old and I do not know its origins
(whether converted from another spreadsheet product, etc). If the contents
of the worksheet are copied to another workbook, this situation is not
copied, i.e., the person needs to use an = sign for formula in the new
workbook. I have not seen the workbook but as far as I am aware the person
is not using the + sign to begin the formula.

We would like to be able to find out how this is achieved in order to create
other workbooks with the same element. Any ideas, anyone???

No need to use = sign in formulas
 

Tools Options Sheet Options and put a check in "Transition formula
entry"

Works with manually entered numbers into the formula but you will not be
able to enter cell references that way.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jack" wrote in message
...
A friend has an Excel workbook that does not require the use of the = sign
to
begin a formula. In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula without an = sign being
entered into the cell. However after the formula has been entered, the =
sign is placed automatically into the cell.

This workbook is at least 10 years old and I do not know its origins
(whether converted from another spreadsheet product, etc). If the
contents
of the worksheet are copied to another workbook, this situation is not
copied, i.e., the person needs to use an = sign for formula in the new
workbook. I have not seen the workbook but as far as I am aware the
person
is not using the + sign to begin the formula.

We would like to be able to find out how this is achieved in order to
create
other workbooks with the same element. Any ideas, anyone???

No need to use = sign in formulas
 

Look into Transition

Tools Options... Transition and check the bottom two checkboxes
--
Gary''s Student - gsnu200788


"jack" wrote:

A friend has an Excel workbook that does not require the use of the = sign to
begin a formula. In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula without an = sign being
entered into the cell. However after the formula has been entered, the =
sign is placed automatically into the cell.

This workbook is at least 10 years old and I do not know its origins
(whether converted from another spreadsheet product, etc). If the contents
of the worksheet are copied to another workbook, this situation is not
copied, i.e., the person needs to use an = sign for formula in the new
workbook. I have not seen the workbook but as far as I am aware the person
is not using the + sign to begin the formula.

We would like to be able to find out how this is achieved in order to create
other workbooks with the same element. Any ideas, anyone???

No need to use = sign in formulas
 

Many thanks.

"Sandy Mann" wrote:

Tools Options Sheet Options and put a check in "Transition formula
entry"

Works with manually entered numbers into the formula but you will not be
able to enter cell references that way.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jack" wrote in message
...
A friend has an Excel workbook that does not require the use of the = sign
to
begin a formula. In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula without an = sign being
entered into the cell. However after the formula has been entered, the =
sign is placed automatically into the cell.

This workbook is at least 10 years old and I do not know its origins
(whether converted from another spreadsheet product, etc). If the
contents
of the worksheet are copied to another workbook, this situation is not
copied, i.e., the person needs to use an = sign for formula in the new
workbook. I have not seen the workbook but as far as I am aware the
person
is not using the + sign to begin the formula.

We would like to be able to find out how this is achieved in order to
create
other workbooks with the same element. Any ideas, anyone???

No need to use = sign in formulas
 

Thank-you. Will certainly check it out when I get access to the worksheet.

"Gary''s Student" wrote:

Look into Transition

Tools Options... Transition and check the bottom two checkboxes
--
Gary''s Student - gsnu200788


"jack" wrote:

A friend has an Excel workbook that does not require the use of the = sign to
begin a formula. In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula without an = sign being
entered into the cell. However after the formula has been entered, the =
sign is placed automatically into the cell.

This workbook is at least 10 years old and I do not know its origins
(whether converted from another spreadsheet product, etc). If the contents
of the worksheet are copied to another workbook, this situation is not
copied, i.e., the person needs to use an = sign for formula in the new
workbook. I have not seen the workbook but as far as I am aware the person
is not using the + sign to begin the formula.

We would like to be able to find out how this is achieved in order to create
other workbooks with the same element. Any ideas, anyone???