View original (French)

S'il vous plaît, comment insérer "FCFA" dans Excel.

Solved
hatta -  
Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   -
Hello,

hello!
I would like to do calculations in CFA francs in Excel; however, it seems that Excel does not recognize CFA, how can I incorporate it into the calculations;
thank you

4 answers

  1.
    Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    Hello hatta.

    "but it didn't work".

    So let's start again together:

    1) Select the range of cells concerned.
    2) Cell format/Number/Currency/
    - confirm.
    3) Cell format/Number/Custom/
    - in the "Type" window, # ##0.00 € is displayed
    - replace € with "FCFA";
    - the display should therefore become # ##0,00 "FCFA"
    - confirm.

    * Do NOT do anything more or less than these instructions!
    --
    It's nice, retirement! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    2
    1. hatta
       
      Thank you, it worked; that's how you have to explain it to the clueless.
      0
  2. hatta
     
    I tried
    cell format/number/custom and replace every time "euro" with "fcfa"
    but it didn't work, this text is displayed "Excel cannot use the format you typed. Try using a predefined number format"
    Please do not hesitate to help me
    1
  3. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    I just found a solution on another site:

    http://forum.telecharger.01net.com/forum/high-tech/LOGICIELS/Bureautique/ajouter-monnaie-excel-sujet_193973_1.htm

    Tested and it works.

    Best regards.
    --
    That guy wasn't the brightest, as he was foolish.
    0
    1. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
       
      Hello chossette9: that's exactly what I suggested!
      0
    2. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
       
      Yes, I know, but apparently he needed a more concrete example.

      But you'll notice that the topic has been marked as resolved, yet no message of thanks or anything...
      0
    3. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
       
      Oh really? It will certainly come when his accounts have been validated!
      0
    4. hatta
       
      Thank you a thousand times chossette9 it worked 100/100.
      Thank you too Raymond.
      0
    5. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
       
      at your service!
      0
  4. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    1) Select the range of cells concerned.
    2) Cell format/Number/Currency/ and confirm.
    3) Cell format/Number/Custom/ and replace every € with "FCFA"; confirm.
    --
    It's nice, retirement! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    -1