covert figure in to text

  • Thread starter Thread starter bmurlidhar
  • Start date Start date
B

bmurlidhar

Anyboy have this function which convert figure into text format or
please give me the link.

best regards

thank you
 
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")







- Show quoted text -
Click to expand...

I meant to convertion from number to words i.e. 10000 (Ten thousand)
 
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")







- Show quoted text -
Click to expand...

convertion from figure to words i.e. 10000 (Tendthousand)
 

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

Issue with pivot table 1
How to convert this text number and fraction to 1 figure using mac 4
Importing Long Numbers as Text cells 1
Which is the best method to convert MSG to PDF? 0
how to convert .3GA to mp3 files? 1
Help on conversion 3
Dates coverted to formulas 3
how to round figures? 2

Back
Top