Hello Siddhi,
Take a try of macro.
code:
Sub AVG()
With Range("A4")
.FormulaR1C1 = "=AVERAGE((R[-3]C+R[-2]C+R[-1]C)/3)"
.Formula = .Value
End With
MsgBox "Done!"
End Sub
Save it in standard module using alt + f11, Insert-module-paste the code and
run it.
Enable all macros. Save file as macro enable. Now you can read the digits
one by one using f2 edit command.
Hope this will solve your problem.
Regards,
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Siddhi Desai" <siddhi.desai1...@gmail.com>
Sent: Wednesday, February 04, 2015 10:08 PM
To: "accessindia" <accessindia@accessindia.org.in>
Subject: [AI] excel queries continued!
Thanks for the comment.
The problem is that that I have too many values in millions and
billionss located near each other with 100/100 matrix. So I was
wondering that is there any way we could read them character by
character within that cell only after entering the formula. as pasting
in other cell creats confusion. is there any laternative way?
Amar, I tried what you said but it displays the formula. for example,
the in the cell a4, there is a formula of an average ((a1+a2+a3)/3)
and the answer is 6. when I use control `. it shows me the average
formula ((a1+a2+a3)/3) where earlier JAWS was announcing "6 has a
formula".
Am I doing correctly? or you were suggesting something else.
Thanking in advance
Sincerely
Siddhi
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..
