View original (French)

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

Solved
hatta -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur 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 réponses

Réponse 1 / 4
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
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
hatta
 
Thank you, it worked; that's how you have to explain it to the clueless.
0
Réponse 2 / 4
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
Réponse 3 / 4
chossette9 Posted messages 6855 Registration date   Status Contributeur 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
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
Hello chossette9: that's exactly what I suggested!
0
chossette9 Posted messages 6855 Registration date   Status Contributeur 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
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
Oh really? It will certainly come when his accounts have been validated!
0
hatta
 
Thank you a thousand times chossette9 it worked 100/100.
Thank you too Raymond.
0
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
at your service!
0
Réponse 4 / 4
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
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