HOW TO CONVERT THE FIGURE IN TO THE WORD IN EXCEL LIKE 10=TEN

  • Thread starter Thread starter mrigendra
  • Start date Start date
M

mrigendra

i want to convert figure in i.e.(135)in to word i.e.(one hundred thirty five
only.)
 
Hi mrigendra

Press Ctrl-F9 and type '=135 \* Cardtext' between the field braces, thus '{=135 \* Cardtext}'. Then press F9 to update the field.
 
Hi mrigendra

My previous reply was for Word.

For Excel, you'll need a custom function. A web search using the 'NumberToText Excel' parameters will return a number of such
functions.

--
Cheers
macropod
[MVP - Microsoft Word]


macropod said:
Hi mrigendra

Press Ctrl-F9 and type '=135 \* Cardtext' between the field braces, thus '{=135 \* Cardtext}'. Then press F9 to update the field.

--
Cheers
macropod
[MVP - Microsoft Word]


mrigendra said:
i want to convert figure in i.e.(135)in to word i.e.(one hundred thirty five only.)
Click to expand...
Click to expand...
 
mrigendra said:
i want to convert figure in i.e.(135)in to word i.e.(one hundred thirty five
only.)
Click to expand...

I want to do the same in MS Access. I also could not find answer to that.
 
Assuming that the number is the result of a field, in Word you would use the
\* CardText switch with the field code. For example: { = 135 \* CardText }
would display "one hundred thirty-five."

To learn if/how this can be done in Access, ask in an Access newsgroup.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Convert MBOX to PST Online? 3
Convert Number To Word ? 2
convert 3
convert number value to words of numerical value 4
Convert Word to Number 4
Conversion from Number to Word!! Aki 1
Figure numbering problem 2
how to convert a number in words (ex: 10 becomes "ten") 2

Back
Top