I want to convert numbers to text in Excel
 

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

Format the cell to Text before you enter the number. Or precede the entry
with an apostrophe. HTH Otto
"Hannibal" wrote in message
...
i.e. 0000176 into exactly the same but as text. How do I do this?

try to use formula text( )

"Hannibal" wrote:

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