Dear Mukesh Sir,
Thanks for the information.
My question was that if you have large number (in billions) and
formula in the same cell. is there anyway where you could read the
number charcter by charcter instead of pasting into other cell? as
when I press f2 JAWS reads to me the formula and not the number.
The average example was to confirm Amar's suggestion.
Thanks for the information though
Sincerely
Siddhi
On 2/4/15, Mukesh Baviskar <mukeshbaviskar....@gmail.com> wrote:
> 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..
>
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..
