Share via

Philippine Peso Symbol

Anonymous
2015-05-07T02:20:07+00:00

I have been using Microsoft Office - Excel for more or less 20 years.  You only have the PHP, Php, PhP as automatic formatting for the numbers with currency.  I'm just wondering why you don't add symbol for Peso just like $ for USD?  You were able to make one for China(¥); Japan(¥); Korea(₩); and, Russia(₽) which is almost similar to Philippine Peso...but...just move the lines a liiiiiittle bit more....upward like this (₱) :) Microsoft Office people/programmers, I hope you add Philippine Peso symbol soon. 

Thank you.

Microsoft 365 and Office | Install, redeem, activate | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2015-05-16T06:08:42+00:00

    I guess, I need to do it the hard way for now.  :(

    You have misunderstood me, you just have to format the cell with the appropriate format:

    After you have formatted the cell once, open the Format Cells window again and choose Custom, then you can see what I have described above.

    Andreas.

    10+ people found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2015-05-08T06:21:22+00:00

    In Excel you have to type the number in the cell and then format the cell with the appropriate number format.

    There is a predefined number format in Excel for the English Philippine Peso:

    [$₱-3409]#,##0.00

    Or maybe you mean "Filipino"

    [$₱-464]#,##0.00

    And you can have (almost) any currency format used around the world, the syntax for currency formats of cells is

    "[$" & Currency Symbol & "-" & Language ID in hex & "]" & usual number format

    Sub Test()

      Dim LanguageID As Long

      Dim CurrencyASCII As Long

      CurrencyASCII = 8369 'The sign in ASCII code

      LanguageID = 13321 'The language id (3409 in hex)

      ActiveCell.NumberFormat = _

        "[$" & ChrW(CurrencyASCII) & "-" & Hex(LanguageID) & "]#,##0.00"

    End Sub

    Execute that and look into the cell format.

    You can also apply that with a formula:

    =TEXT(1,"[$₱-3409]#.##0,00")

    Andreas.

    5 people found this answer helpful.
    0 comments
  3. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2015-05-07T07:27:58+00:00

    You can get Philippine Peso symbol by typing "20b1" (without the quotes) and then press the Alt and X buttons simultaneously

    It does not work in these forums, but does work in Word.

    If you have the Philippines National Keyboard layout, you can also insert it by using the Right Alt key+p

    See http://jcsesecuneta.com/tome/labox/philippines-national-keyboard-layout-now-available-for-windows/

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-05-07T11:33:07+00:00

    Hello! Thank you very much for your reply. What I meant was the automatic formatting of the numbers in Excel.  Sorry, I should've been more specific. ^_^ 

    I'll edit now my entry. :)

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2015-05-16T04:06:14+00:00

    Wow. That's a lot of programming stuff. Thank you very much for your help.  But, I was hoping that Microsoft Excel could provide something readily available in the software like those other countries' currency that I have mentioned. I guess, I need to do it the hard way for now.  :(

    0 comments