View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default covert figure in to text

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