EXCEL convert numbers to words - invoice
Solved
roland
-
JBB -
JBB -
Hello everyone,
I'm trying to create an invoice in Excel
Is there a possibility that if I enter the invoice amount in numbers, it will automatically input the amount in words?
Because it's annoying to write the amount in words every time
Thank you all
I'm trying to create an invoice in Excel
Is there a possibility that if I enter the invoice amount in numbers, it will automatically input the amount in words?
Because it's annoying to write the amount in words every time
Thank you all
4 réponses
to format this number in words
.Create a field with CTRL-F9
* {} will appear on the screen
* Fill it with the desired value preceded by '=' and followed by a code indicating to Word to format this field in a specific way \*cardtext
for example: {=1128\*cardtext}
* Reposition in the field if not already there
* Press F9 to update the field value
* The number will appear in words: one thousand one hundred twenty-eight
.Create a field with CTRL-F9
* {} will appear on the screen
* Fill it with the desired value preceded by '=' and followed by a code indicating to Word to format this field in a specific way \*cardtext
for example: {=1128\*cardtext}
* Reposition in the field if not already there
* Press F9 to update the field value
* The number will appear in words: one thousand one hundred twenty-eight
for your tip
Randrianifanafana JEAN REMI (Madagascar)