View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
bmurlidhar bmurlidhar is offline
external usenet poster
 
Posts: 14
Default covert figure in to text

On Oct 3, 5:47*pm, Sheeloo wrote:
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")



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


best regards


thank you- Hide quoted text -


- Show quoted text -


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