Thread
:
excel shouldnt need a symbol before the first number in an equati
View Single Post
#
2
Bernard Liengme
Posts: n/a
Actually it is = that must be used.
For example =12+6 gives 18 but 12+6 gives text
I sometimes wish 12+6 would be recognized as a formula but Excel needs the =
to know that a formula is being entered
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"stewart katz" <stewart
wrote in message
...
Whilst excel accepts a number as positive when first entered, why when
adding
further entries in the cell do you have to enter a ' +' symbol before the
first number.
Surely it must be intuitive that this is going to be a formula, and that a
+
symbol could then be automatically programmed for.
Supercalc (which I used for many years before even Microsoft appeared )
and
Lotus 123 both had this feature, and this saved quite a lot of time and
frustration
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...et.f unctions
Reply With Quote