| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to convert a number to text but I need it to be 5 position
=TEXT(A1,"00000")
-- Kind regards, Niek Otten Microsoft MVP - Excel "Mike L." <Mike wrote in message ... |I need to convert a number to text but it needs to be 5 positions. For | example of the number is 100, I need the text value to be 00100. | | Any Ideas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text number to number formate | Excel Discussion (Misc queries) | |||
| How to convert a number to text | Excel Discussion (Misc queries) | |||
| find number position in excel text cell | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Hybrid Mode
