tag:blogger.com,1999:blog-9312877.post112537662775251247..comments2022-12-09T12:19:07.505-07:00Comments on Excel Tips: Keyboard Shortcuts to Insert Special Symbols in ExcelJon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-9312877.post-82900475566190131882016-10-17T01:55:20.080-07:002016-10-17T01:55:20.080-07:00Please someone can help me if A is my demands &...Please someone can help me if A is my demands & B is Inventory-In then if Invntory-In show "OK" otherwise "Pending" <br />e.g<br /><br />A B C<br />30 30 OK<br />30 25 PendingAnonymoushttps://www.blogger.com/profile/07925698136786222782noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-70417948396863925062014-09-11T23:26:04.081-07:002014-09-11T23:26:04.081-07:00TYVM you made my day :)TYVM you made my day :)Anonymoushttps://www.blogger.com/profile/17865802102814513696noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-91968831575256847962014-02-06T07:22:08.150-07:002014-02-06T07:22:08.150-07:00For 1/2 symbol, hold alt-button and type "171...For 1/2 symbol, hold alt-button and type "171" with your numpad.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-80380805001744373632013-12-16T16:58:59.857-07:002013-12-16T16:58:59.857-07:00You can use the common + keypad numbers to add sy...You can use the common + keypad numbers to add symbols (including ½) to Excel. ½, for example, is 0189. BUT, you can't do math with it. Not all of them work, but the ones that do are easier that the auto-correct solution. 0176 = ° , 0177 = ±, 227 = π etc.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-68435637350273659212012-03-06T19:13:23.922-07:002012-03-06T19:13:23.922-07:00why isn't there a 1/2 in Excel Symbol?why isn't there a 1/2 in Excel Symbol?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-914152416416041872012-01-27T19:53:01.387-07:002012-01-27T19:53:01.387-07:00there's no 1/2 in excel symbolthere's no 1/2 in excel symbolAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-51033417179915450872011-11-02T03:21:00.303-07:002011-11-02T03:21:00.303-07:00HOW TO ENTER LATIN CHARACTERS LIKE PHI, PI , ETC T...HOW TO ENTER LATIN CHARACTERS LIKE PHI, PI , ETC THROUGH KEYBOARD SHORTCUTvivekhttps://www.blogger.com/profile/07557459443030472628noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-27927031784951846162011-07-09T16:43:30.771-07:002011-07-09T16:43:30.771-07:00Thanks a lotThanks a lotAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-51438053977517544942011-06-03T04:39:27.729-07:002011-06-03T04:39:27.729-07:00thank you so much .thank you so much .Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-90512297491988437812009-06-24T18:36:32.584-07:002009-06-24T18:36:32.584-07:00This is big help for me, thank you so much.This is big help for me, thank you so much.mhyh_jvhttps://www.blogger.com/profile/00744540288448340385noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-3445570976236405942009-03-12T18:52:00.000-07:002009-03-12T18:52:00.000-07:00To UNDO an autocorrect, press Ctrl+z (or undo) imm...To UNDO an autocorrect, press Ctrl+z (or undo) immediately after the symbol changes. So, if you want (R) and not (®), then UNDO immediately after the autocorrect occurs.Jon Wittwerhttps://www.blogger.com/profile/04461947852006005549noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-33224101406199205572009-01-19T14:15:00.000-07:002009-01-19T14:15:00.000-07:00How do I turn this auto feature off? For my accoun...How do I turn this auto feature off? For my accounting homework I literally need to type (R) to classicy an account as revenue but excel automatically gives me the registered trademark symbolAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-1157123278874607632006-09-01T08:07:00.000-07:002006-09-01T08:07:00.000-07:00This is a great help. Thanks for posting.This is a great help. Thanks for posting.Anonymousnoreply@blogger.com