ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how i can make the numbers (https://www.excelbanter.com/excel-discussion-misc-queries/2653-how-i-can-make-numbers.html)

fatih terzioglu

how i can make the numbers
 
hi i am fatih
fistly sorry my english is not good
my trouble is haw can i will write the number of the
contribution

for example 1.000.000.000
=yaziyla(b42) (one milyar)
and tahan my office version is turkish version
thank you so your company will interesting my problem


Bob Phillips

Fatih,

If I understand you correctly, you want a formula to translate numbers to
words (in Turkish).

Laurent Longre has a language version of an function which offers this
capability. It is at http://longre.free.fr/english/

I don't know if it supports Turkish, but if not, send me the Turkish words
for all the numbers, one, tow, ..., one thousand, two thousand, one million
etc., and I will knock you up a function that does it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fatih terzioglu" wrote in message
...
hi i am fatih
fistly sorry my english is not good
my trouble is haw can i will write the number of the
contribution

for example 1.000.000.000
=yaziyla(b42) (one milyar)
and tahan my office version is turkish version
thank you so your company will interesting my problem





All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com