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" <[email protected]>
Sent: Wednesday, October 03, 2012 6:49 PM
To: <[email protected]>
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" <[email protected]>
To: "Access India" <[email protected]>
Cc: "Zujar Shabbir Kanchwala" <[email protected]>
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/[email protected]/

To unsubscribe send a message to
[email protected]
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/[email protected]/

To unsubscribe send a message to
[email protected]
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/[email protected]/

To unsubscribe send a message to
[email protected]
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

Reply via email to