I want to convert numbers to text in Excel

Guest · Feb 28, 2005

i.e. 0000176 into exactly the same but as text. How do I do this?

Otto Moehrbach · Feb 28, 2005

Format the cell to Text before you enter the number. Or precede the entry
with an apostrophe. HTH Otto

Guest · Feb 28, 2005

try to use formula text( )

Changing Text To Numbers ?	1	Mar 3, 2013
Which is the best MBOX Converter Tool different formats conversion?	5	Apr 10, 2025
Converting a text word or text string to a number	6	Jan 2, 2009
Convert Numbers to Text	4	Sep 10, 2009
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation	1	Oct 5, 2012
Columns formatted As Dates Are Exported as a Number to Text	1	Feb 7, 2010
Converting excel 2007 to tab delimeter text file	1	Mar 26, 2010
How to convert text "JAN" into number 1?	9	Apr 10, 2010

Ask a Question