Re: [AI] excel queries continued!

2015-02-05 Thread Amar Jain
Siddhi: no idea of how to read the value character by character, but this keystroke allows you to switch between formula and values. So once pressed, it will read as formula, and upon next press, it will read the value. But you may not be able to use the edit mode to check the value as per my

Re: [AI] excel queries continued!

2015-02-05 Thread Vyas Gajendra
@accessindia.org.in Sent: Thursday, February 05, 2015 1:44 PM Subject: Re: [AI] excel queries continued! Siddhi: no idea of how to read the value character by character, but this keystroke allows you to switch between formula and values. So once pressed, it will read as formula, and upon next press

Re: [AI] excel queries continued!

2015-02-04 Thread Mukesh Baviskar
: 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

[AI] excel queries continued!

2015-02-04 Thread Siddhi Desai
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

Re: [AI] excel queries continued!

2015-02-04 Thread Siddhi Desai
] 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

Re: [AI] excel queries continued!

2015-02-04 Thread Mukesh Baviskar
siddhi.desai1...@gmail.com Sent: Wednesday, February 04, 2015 11:25 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] excel queries continued! Dear Mukesh Sir, Thanks for the information. My question was that if you

Re: [AI] excel queries continued!

2015-02-04 Thread Mahesh Narasimhan
Dear Siddhi, Only to add to the average formula, instead of using the formula =((A1+A2+A3)/3), you can use =AVERAGE (A1:A3). I don't know any other method to find the values other than what was mentioned in the list. -- Good friendship is like the relationship between eye hand! If the hand is