Hi David
It is the cell format. I couldn't get it to go wrong until I changed
the format of the cell and then tried entering it again.
In that cell, I can also do +6/2 OK, but not +6/2.0. =6/2.0 works fine
though.
More interesting still (Excel 2003) ... if I put +6/2 into a
default-format cell, the formula bar shows =6/2; but if I put +6/2 into
my formatted cell, the formula bar shows 3. Enter =6/2 in the formatted
cell and it shows =6/2.
Note that it's not YOUR cell format that is the problem. If I format
the cell as Number, it gives the same results.
Time to learn to use "=". :-)
(Easier to type anyway.)
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of David Grugeon
Sent: Friday, 19 October 2012 13:25
To: excelvba@yahoogroups.com
Subject: [ExcelVBA] slightly OT - use of + key
Hi all
Hope you don't mind for once a non VBA issue.
I have for years started formulas with the plus key (+) rather than an
Equals(=). Excel has always accepted this and converts the + to and = on
the formula bar when you press enter or move.
I can still do that. And it works except on one sheet in one book.
In this one sheet I can enter +6/2 and enter and it displays 3 and the
formula in the formula bar is =6/2. As expected.
However if I type +1/1.4 I get the message "The formula you typed
contains
an error" followed by info about how to press the help button etc. When
I
click OK the 1.4 is highlighted. It is almost as though the sheet had
been
set to work with integers only but it is ok with +1+1.4
I emphasise that this is only on this one sheet. Other sheets in the
workbook are OK - Actually it also exists in the sheet I copied some
stuff
into this sheet.
I do not think it is the cell format but that is
#,##0.00_);[Red](#,##0.00);"-"??_-;_-@_-
Any ideas - it drives me nuts not to be able to use keystrokes which are
now
automatic!
Best Regards
David Grugeon
Excel VBA Group Moderator
[Non-text portions of this message have been removed]
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar