Re: [AI] Type dash in excel cell
Dear Umesha, Thank you. It's working fine. Only I have to take care to use enter key rather than arrow key. Good night. Regards Mukesh Baviskar Mobile: 9403161157 -- From: "Umesha Economics" Sent: Wednesday, October 03, 2012 6:49 PM To: Subject: Re: [AI] Type dash in excel cell dear mukesh, as I checked with excel XP, it worked. one thing you have to ensure. after typing dash, press enter and do not use arrow keys to go to another cell. otherwise, excel tries to insert a formula. if you type 2 or more dashes, after pressing enter key, you may get an error message box. ignore it and hit another enter. I hope the same holds with later versions of excel also. Umesha - Original Message - From: "Mukesh" To: "Access India" Cc: "Zujar Shabbir Kanchwala" Sent: Wednesday, 03 October, 2012 7:34 AM Subject: [AI] Type dash in excel cell Hello friends, I have a column in excel database namely 'email'. Some of the teachers don't have a email id so I want to type dash instead of leaving the cell blank. But excel didn't accept the dash sign in cell. Any solution to type dash sign in cell? Regards Mukesh Baviskar Mobile: 9403161157 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 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 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
Re: [AI] Type dash in excel cell
dear mukesh, as I checked with excel XP, it worked. one thing you have to ensure. after typing dash, press enter and do not use arrow keys to go to another cell. otherwise, excel tries to insert a formula. if you type 2 or more dashes, after pressing enter key, you may get an error message box. ignore it and hit another enter. I hope the same holds with later versions of excel also. Umesha - Original Message - From: "Mukesh" To: "Access India" Cc: "Zujar Shabbir Kanchwala" Sent: Wednesday, 03 October, 2012 7:34 AM Subject: [AI] Type dash in excel cell Hello friends, I have a column in excel database namely 'email'. Some of the teachers don't have a email id so I want to type dash instead of leaving the cell blank. But excel didn't accept the dash sign in cell. Any solution to type dash sign in cell? Regards Mukesh Baviskar Mobile: 9403161157 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 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
Re: [AI] Type dash in excel cell
I really din't understand the last 2 mails. may be they are replying on a wrong thread. members, please post your replies in the particular threads. Umesha - Original Message - From: "George Abraham" To: Sent: Wednesday, 03 October, 2012 10:56 AM Subject: Re: [AI] Type dash in excel cell In your country Doris! Will be here till Friday night! Regards, George -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Doris and Chris Sent: 03 October 2012 09:10 To: accessindia@accessindia.org.in Subject: Re: [AI] Type dash in excel cell Hi, My favorite - and quite self-explanatory - is FS Reader from Freedom Scientific. Originally a commercial product, it now comes free bundled with jaws. You can download and install the jaws demo and it will stay behind even when you uninstal jaws. Amos is another free and open source choice. hth Doris At 09:05 AM 10/3/2012 +0530, you wrote: It ideally should. But why not type N/A instead of a - ? is it because you do not want to type two extra characters? -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mukesh Sent: 03 October 2012 07:35 To: Access India Cc: Zujar Shabbir Kanchwala Subject: [AI] Type dash in excel cell Hello friends, I have a column in excel database namely 'email'. Some of the teachers don't have a email id so I want to type dash instead of leaving the cell blank. But excel didn't accept the dash sign in cell. Any solution to type dash sign in cell? Regards Mukesh Baviskar Mobile: 9403161157 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 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 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 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 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
Re: [AI] Type dash in excel cell
In your country Doris! Will be here till Friday night! Regards, George -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Doris and Chris Sent: 03 October 2012 09:10 To: accessindia@accessindia.org.in Subject: Re: [AI] Type dash in excel cell Hi, My favorite - and quite self-explanatory - is FS Reader from Freedom Scientific. Originally a commercial product, it now comes free bundled with jaws. You can download and install the jaws demo and it will stay behind even when you uninstal jaws. Amos is another free and open source choice. hth Doris At 09:05 AM 10/3/2012 +0530, you wrote: >It ideally should. But why not type N/A instead of a - ? is it because >you do not want to type two extra characters? > >-Original Message- >From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On >Behalf Of Mukesh >Sent: 03 October 2012 07:35 >To: Access India >Cc: Zujar Shabbir Kanchwala >Subject: [AI] Type dash in excel cell > >Hello friends, >I have a column in excel database namely 'email'. Some of the teachers >don't have a email id so I want to type dash instead of leaving the cell blank. >But excel didn't accept the dash sign in cell. Any solution to type >dash sign in cell? > >Regards > >Mukesh Baviskar >Mobile: 9403161157 > >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 > > > >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 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 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
Re: [AI] Type dash in excel cell
Hi, My favorite - and quite self-explanatory - is FS Reader from Freedom Scientific. Originally a commercial product, it now comes free bundled with jaws. You can download and install the jaws demo and it will stay behind even when you uninstal jaws. Amos is another free and open source choice. hth Doris At 09:05 AM 10/3/2012 +0530, you wrote: It ideally should. But why not type N/A instead of a - ? is it because you do not want to type two extra characters? -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mukesh Sent: 03 October 2012 07:35 To: Access India Cc: Zujar Shabbir Kanchwala Subject: [AI] Type dash in excel cell Hello friends, I have a column in excel database namely 'email'. Some of the teachers don't have a email id so I want to type dash instead of leaving the cell blank. But excel didn't accept the dash sign in cell. Any solution to type dash sign in cell? Regards Mukesh Baviskar Mobile: 9403161157 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 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 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
Re: [AI] Type dash in excel cell
It ideally should. But why not type N/A instead of a - ? is it because you do not want to type two extra characters? -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mukesh Sent: 03 October 2012 07:35 To: Access India Cc: Zujar Shabbir Kanchwala Subject: [AI] Type dash in excel cell Hello friends, I have a column in excel database namely 'email'. Some of the teachers don't have a email id so I want to type dash instead of leaving the cell blank. But excel didn't accept the dash sign in cell. Any solution to type dash sign in cell? Regards Mukesh Baviskar Mobile: 9403161157 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 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
[AI] Type dash in excel cell
Hello friends, I have a column in excel database namely 'email'. Some of the teachers don't have a email id so I want to type dash instead of leaving the cell blank. But excel didn't accept the dash sign in cell. Any solution to type dash sign in cell? Regards Mukesh Baviskar Mobile: 9403161157 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