|
Bildirim
|
|
|
< Bu mesaj bu kişi tarafından değiştirildi serseri -- 24 Temmuz 2006; 18:35:56 > |
|
|
|
|
A1 hücresine yazdığınız sayıyı aşağıdaki formülle yazıya çevirebilirsiniz: regional settings'de list seperator = "," (virgül) için: =CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),1,1)+1,"","","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),1,1)<>"0","YÜZ","")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),2,1)+1,"","ON","YİRMİ","OTUZ","KIRK","ELLİ","ALTMIŞ","YETMİŞ","SEKSEN","DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),3,1)+1,"","BİR","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(AND(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),3,1)="0",MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),2,1)="0",MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),12),1,1)="0"),"","MİLYAR")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),1,1)+1,"","","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),1,1)<>"0","YÜZ","")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),2,1)+1,"","ON","YİRMİ","OTUZ","KIRK","ELLİ","ALTMIŞ","YETMİŞ","SEKSEN","DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),3,1)+1,"","BİR","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(AND(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),3,1)="0",MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),2,1)="0",MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),9),1,1)="0"),"","MİLYON")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),1,1)+1,"","","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),1,1)<>"0","YÜZ","")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),2,1)+1,"","ON","YİRMİ","OTUZ","KIRK","ELLİ","ALTMIŞ","YETMİŞ","SEKSEN","DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),3,1)+1,"","BİR","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(AND(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),3,1)="0",MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),2,1)="0",MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),6),1,1)="0"),"","BİN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),3),1,1)+1,"","","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),3),1,1)<>"0","YÜZ","")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),3),2,1)+1,"","ON","YİRMİ","OTUZ","KIRK","ELLİ","ALTMIŞ","YETMİŞ","SEKSEN","DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1,0),"000000000000"),3),3,1)+1,"","BİR","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&"TÜRKLİRASI"&CHOOSE(MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1,0)),"000"),3),2,1)+1,"","ON","YİRMİ","OTUZ","KIRK","ELLİ","ALTMIŞ","YETMİŞ","SEKSEN","DOKSAN")&CHOOSE(MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1,0)),"000"),3),3,1)+1,"","BİR","İKİ","ÜÇ","DÖRT","BEŞ","ALTI","YEDİ","SEKİZ","DOKUZ")&IF(AND(MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1,0)),"000"),3),3,1)="0",MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1,0)),"000"),3),2,1)="0"),"","KURUŞ")regional settings'de list seperator = ";" (noktalı virgül) için: =CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);1;1)+1;"";"";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);1;1)<>"0";"YÜZ";"")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);2;1)+1;"";"ON";"YİRMİ";"OTUZ";"KIRK";"ELLİ";"ALTMIŞ";"YETMİŞ";"SEKSEN";"DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);3;1)+1;"";"BİR";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(AND(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);3;1)="0";MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);2;1)="0";MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");12);1;1)="0");"";"MİLYAR")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);1;1)+1;"";"";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);1;1)<>"0";"YÜZ";"")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);2;1)+1;"";"ON";"YİRMİ";"OTUZ";"KIRK";"ELLİ";"ALTMIŞ";"YETMİŞ";"SEKSEN";"DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);3;1)+1;"";"BİR";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(AND(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);3;1)="0";MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);2;1)="0";MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");9);1;1)="0");"";"MİLYON")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);1;1)+1;"";"";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);1;1)<>"0";"YÜZ";"")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);2;1)+1;"";"ON";"YİRMİ";"OTUZ";"KIRK";"ELLİ";"ALTMIŞ";"YETMİŞ";"SEKSEN";"DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);3;1)+1;"";"BİR";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(AND(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);3;1)="0";MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);2;1)="0";MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");6);1;1)="0");"";"BİN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");3);1;1)+1;"";"";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");3);1;1)<>"0";"YÜZ";"")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");3);2;1)+1;"";"ON";"YİRMİ";"OTUZ";"KIRK";"ELLİ";"ALTMIŞ";"YETMİŞ";"SEKSEN";"DOKSAN")&CHOOSE(MID(RIGHT(TEXT(ROUNDDOWN(A1;0);"000000000000");3);3;1)+1;"";"BİR";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&"TÜRKLİRASI"&CHOOSE(MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1;0));"000");3);2;1)+1;"";"ON";"YİRMİ";"OTUZ";"KIRK";"ELLİ";"ALTMIŞ";"YETMİŞ";"SEKSEN";"DOKSAN")&CHOOSE(MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1;0));"000");3);3;1)+1;"";"BİR";"İKİ";"ÜÇ";"DÖRT";"BEŞ";"ALTI";"YEDİ";"SEKİZ";"DOKUZ")&IF(AND(MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1;0));"000");3);3;1)="0";MID(RIGHT(TEXT(100*(A1-ROUNDDOWN(A1;0));"000");3);2;1)="0");"";"KURUŞ")< Bu mesaj bu kişi tarafından değiştirildi ferguson81 -- 15 Eylül 2021; 22:50:45 > |
biraz geç oldu ama belki birinin işine yarar. https://archive.ismmmo.org.tr/yardimciprogramlar/makro_ekle.pdf |