In that case, go to Format menu, Style submenu, and make sure, Normal style
is selected. Also activate the Modify option and check all the options
inside the Modify dialogue box. When I do the accounts, I select number with
two decimal places in the Modify style dialogue box and it renders all
numbers into proper formats inside the entire workbook.
Best regards,
Amiyo Biswas
Cell: 91-9433464329
----- Original Message -----
From: "Himanshu Sahu" <sahu.himanshu2...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Monday, February 14, 2011 10:45 AM
Subject: Re: [AI] An Excel question - would appreciate a quick response
Sorry for the delayed response Dada.
I unchecked all the check boxes in Option/Edit Tab Page sequentially ,
but the problem is still persisted.
On 2/12/11, Amiyo Biswas <amiyo.bis...@gmail.com> wrote:
What's not working, the shortcuts or the options?
Best regards,
Amiyo Biswas
Cell: 91-9433464329
----- Original Message -----
From: "Himanshu Sahu" <sahu.himanshu2...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Friday, February 11, 2011 4:45 PM
Subject: Re: [AI] An Excel question - would appreciate a quick response
Sorry, its not working...
On 2/11/11, Amiyo Biswas <amiyo.bis...@gmail.com> wrote:
Hello,
You can explore options under Tools menu. Perhaps some feature has been
turned on on the edit tab. It is converting the value automatically
into
date format. In my case, the number 10/10000 remains unaffected.
You can always use the shortcut keys for cell format:
Ctrl+shift+1: for two decimal places
Ctrl+shift+2: for time in format "h:mm AM/PM"
Ctrl+shift+3: for date in format "d-mmm-yy"
Best regards,
Amiyo Biswas
Cell: 91-9433464329
----- Original Message -----
From: "Himanshu Sahu" <sahu.himanshu2...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Thursday, February 10, 2011 10:44 AM
Subject: Re: [AI] An Excel question - would appreciate a quick response
I too have one problem and that is whenever I type any number/another
number or number . another number like, 10/10000, or 10.10000, it
appears in the form of date/month/year. Any suggestion that where from
I need to disable this format?
On 2/10/11, Amiyo Biswas <amiyo.bis...@gmail.com> wrote:
Very interesting, never faced a problem like this. Can you send me a
sample
file with such data for an idea?
Best regards,
Amiyo Biswas
Cell: 91-9433464329
----- Original Message -----
From: "bharatvaya" <bharatv...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Wednesday, February 09, 2011 8:18 AM
Subject: Re: [AI] An Excel question - would appreciate a quick
response
I have 1 problem is that when I type any value for example 55 it
appears
0.55 any solution?
----- Original Message -----
From: "Amiyo Biswas" <amiyo.bis...@gmail.com>
To: "Geetha Shamanna" <gee...@millernorbert.de>;
<accessindia@accessindia.org.in>
Sent: Wednesday, February 09, 2011 6:09 AM
Subject: Re: [AI] An Excel question - would appreciate a quick
response
I normally select the entire column using ctrl+spacebar and then
activate
the autofit o;submenu under, column under format menu. It fits the
column
according to the largest cell in the column.
Normally, I use ctrl+a to select all and then use the text wrap
checkbox
on alignment tab of the vormat cell dialogue box under format menu.
overlapping data is very likely to escape our notice when thousands
of
cells are there. It is not possible to check so many cells using
the
jaws
verbosity feature.
Best regards,
Amiyo Biswas
Cell: 91-9433464329
----- Original Message -----
From: "Geetha Shamanna" <gee...@millernorbert.de>
To: <accessindia@accessindia.org.in>
Sent: Wednesday, February 09, 2011 1:17 AM
Subject: Re: [AI] An Excel question - would appreciate a quick
response
Thank you, this tip is very helpful.
----- Original Message -----
From: "Arvind Bhartiya" <arvind.bhart...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Tuesday, February 08, 2011 5:00 PM
Subject: Re: [AI] An Excel question - would appreciate a quick
response
Hi! Vamshi:
Data sometimes spills out of the cell and jaws will not normally
alert
you if that has happened. But there is a way that you are alerted
in
such a case once you move to that particular cell.
Activate jaws verbosity by pressing insert v. Then hit c couple of
times till you hear cell text visibility . By default this is
off.
press space to turn it on and hit enter.
Now if you come over a cell with data spilling out jaws will alert
you
by saying for example cell a1 overlapps to cell b1.
This is an indication that data in cell a1 is overflowing to cell
b1
and you can do the needful.
Hope this answers your query.
regards
Arvind
On 2/8/11, Vamshi. G <gvamsh...@gmail.com> wrote:
Hi Geetha,
If you are using Office 2003, you can autofit the columns by
going
to
format menu, and selecting the option column. This increases the
width of the column to the cell which has the highest width.
Alternatively, you can go to format menu, cells, alignment tab,
and
wrap the text of that particular cell so that the content in the
cell
gets adjusted in more than one line without increasing the width
of
the cell.
But I don't know how to know which are the columns that need to
be
adjusted. Jaws reads all the columns identically. Can someone
explain this?
--
G. Vamshi
PH Res : +91 877-2243861
Mobile: +91 9949349497
E-mail ID:
gvamsh...@gmail.com
Skype: gvamshi81
www.retinaindia.org
From darkness unto light
On 2/8/11, Geetha Shamanna <gee...@millernorbert.de> wrote:
Hello all,
I am working on an Excel file in which several cells have lot of
data.
Jaws
always reads everything out; however, I am not sure whether
everything
that
is in a cell is being displayed on the screen. How do I reformat
the
cell
so
that everything appears on the screen? Do I need to use the
auto-fit
option?
Where exactly is it located?
Many thanks.
Geetha
Get numbers right this time, help the census with correct
disability
info!
Get numbers right this time, help the census with correct
disability
info!
Get numbers right this time, help the census with correct
disability
info!
Get numbers right this time, help the census with correct
disability
info!
Get numbers right this time, help the census with correct
disability
info!
Get numbers right this time, help the census with correct disability
info!
Get numbers right this time, help the census with correct disability
info!
--
Thanks and regards
Himanshu Sahu
Reach: 09051055000
Get numbers right this time, help the census with correct disability
info!
Get numbers right this time, help the census with correct disability
info!
--
Thanks and regards
Himanshu Sahu
Reach: 09051055000
Get numbers right this time, help the census with correct disability
info!
Get numbers right this time, help the census with correct disability
info!
--
Thanks and regards
Himanshu Sahu
Reach: 09051055000
Get numbers right this time, help the census with correct disability info!
Get numbers right this time, help the census with correct disability info!
