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!