Convert numbers to text format:

Closed
Alizak Posts 1 Registration date Wednesday December 12, 2012 Status Member Last seen December 12, 2012 - Dec 12, 2012 at 06:07 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Dec 20, 2012 at 06:12 AM
Hello,

i got a problem in my data. there are many soluations already available for converting text format to number. But how can number format can be converted into text.

Once it is converted in text, there should be green mark on the left cell!

Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 12, 2012 at 11:06 AM
You can simply format the cell as text. I must be missing some thing here
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Dec 20, 2012 at 06:12 AM
You Can also Use "text" Function. e.g.

= Text(ReferenceCell, "##")
0