| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want to convert numbers to text in Excel
i.e. 0000176 into exactly the same but as text. How do I do this?
|
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
try to use formula text( )
"Hannibal" wrote: i.e. 0000176 into exactly the same but as text. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| roundoff when converting text to numbers | Excel Worksheet Functions | |||
| convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
| excel - numbers as text | New Users to Excel | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
