Previous Topic Next Topic

Convert numbers to text format:

Closed
Alizak Posts 1 Registration date Wednesday 12 December 2012 Status Member Last seen 12 December 2012 - 12 Dec 2012 à 06:07
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 20 Dec 2012 à 06:12
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

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

= Text(ReferenceCell, "##")

Similar discussions

How to convert number into text in Excel
boratechandu -
Raj -

9 responses
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses