How to type special character like PI, lambda in spreadsheet?

Posted by: changing on 8 September 2017, 3:25 pm EST

  • Posted 8 September 2017, 3:25 pm EST

    The attach figure shows the characters I want to type in.

  • Replied 8 September 2017, 3:25 pm EST

    Hello,

    There are a couple of ways doing the same:-

    1) Using Spread Win Designer wherein you can use Insert> Symbol option from the Spread Win Designer for inserting unicode characters into cell:-
    http://sphelp.grapecity.com/WebHelp/SpreadNet10/WF/webframe.html#spwin-spd-menu-insert.html

    2) Indirectly using keyboard shortcuts:-
    http://www.tedmontgomery.com/tutorial/altchrc-a.html

    Here make certain that the Num Lock key has been pressed to activate the numeric key section of the keyboard.
    Then Depress the Alt key. While the Alt key is depressed, type the proper sequence of numbers (on the numeric keypad) of the ALT code from the table above. Release the Alt key, and the character will appear. For example :- ALT + 227( from Numeric Keypad) will result in "π" symbol.

    3) Using Character Map which is a utility included with Microsoft Windows operating systems and is used to view the characters in any installed font, to check what keyboard input (Alt code) is used to enter those characters, and to copy characters to the clipboard in lieu of typing them.
    https://www.isunshare.com/windows-8/open-windows-8-character-map.html

    Hope it helps.

    Thanks,
    Reeva
  • Replied 8 September 2017, 3:25 pm EST

    Hi Reeva,
    I have tried all these three ways, but failed. Is the reason that the character sheet of spread doesn't have these special characters so that the ways fail?
  • Marked as Answer

    Replied 8 September 2017, 3:25 pm EST

    Hello,

    Could you please clarify that what do you mean by saying "the character sheet of spread doesn’t have these special characters" . When i tried it in Spread using either of 3 above mentioned methods then it worked fine.

    Please confirm and if possible please send a video and steps to replicate the issue which you are facing now. We will look into the same thereon.

    Thanks,
    Reeva

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels