No need to use = sign in formulas

[jack]

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???

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gary''s Student]

Look into Transition

Tools > Options... > Transition > and check the bottom two checkboxes

 

[jack]

Many thanks.

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[jack]

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