Hellow Friends, I want to know is it possible to do the following
I am using Excel 2007 version. I have added in Auto Correct option -- Replace [ .m] & With No. ---- [ 34/09/11/0000] It works properly -- but i want to do that i have to enter always some no. after that say ex. 359535 etc Now what happen is whenever i type in the cell .m -- it replace with 34/09/11/0000 but then cursor move down or what ever postion u give it go to that may be right - left etc But i want whenever i put .m--- then my cursor should be in the same cell & i can put some no. directly without using --- go to that cell - then press F2 -- then it gives me to add. Have a nice day & thanks in advance . J C SHAH -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
