Käynnissä

Visual Basic for Applications 7.1 for Excel 2013

I have found a script on the net that is provided by Microsoft to convert numerals to currency in Excel 2013.

I want it to convert any numerals up to 10,000 including any decimal fractions into words.

I have been able without any previous knowledge in visual basic to do part of what I want (I know it has not been cleanly done).

I would like you to edit this file or create from scratch one that will do as I want in the example below.

It is to be used in Excel 2013 as a formula?

1 = One

10 = Ten

11 = Eleven

100 = One Hundred

101 = One Hundred and One

110 = One Hundred and Ten

1,000 = One Thousand

1,001 = One Thousand and One

1,110 = One Thousand One Hundred and Ten

1,101 = One Thousand One Hundred and One

[url removed, login to view] = Ten point Ten

10.1 = Ten point One

[url removed, login to view] = Ten point Zero One

1,[url removed, login to view] = One Thousand One Hundred and One point Zero One

Thank you

Daniel.

Taidot: Visual Basic for Apps

Näytä lisää: visual basic applications, microsoft visual basic applications, visual basic excel 2013, visual basic applications 2013, 2013, visual basic 2013, excel 2013 visual, excel 2013 visual basic, 2013 excel visual basic, microsoft visual, visual basic edit, excel visual basic, excel 2013, convert currency excel, excel convert words, excel 2013 formula, excel convert formula, visual basic currency, microsoft excel script, microsoft excel 2013, visual currency, example visual basic, excel edit, convert visual net, edit excel

About the Employer:
( 1 review ) St Leonards, Australia

Projektin tunnus: #4239142

Myönnetty käyttäjälle:

excel4engineers

Please refer to my private message to get my exclusive offer.

30 $ USD 1 päivässä
(10 arvostelua)
2.9

4 freelanceria on tarjonnut keskimäärin 39 $ tähän työhön

svet63

See PM. Regards, Svet.

50 $ USD 0 päivässä
(4 arvostelua)
4.2
mrbrave

Lets start....I am VBA expert with great experience in this field.

40 $ USD 1 päivässä
(4 arvostelua)
3.1
studious

Most of the job is alerady done, your script need little modifications to convert numbers. I can help you doing that in few minutes.

35 $ USD 1 päivässä
(0 arvostelua)
0.0