| 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
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to convert a number to text but I need it to be 5 position
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to convert a number to text but I need it to be 5 position
Use a help column and a formula
=TEXT(A1,"00000") where A1 holds 100, after you are done copying the formula, then select all formula results and copy them, then paste special as values in place -- Regards, Peo Sjoblom "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to convert a number to text but I need it to be 5 position
With
A1: 100 Try this: B1: =TEXT(A1,"00000") Is that something you can work with? Does that help? *********** Regards, Ron XL2002, WinXP "Mike L." wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to convert a number to text but I need it to be 5 position
Format/Cells/Custom tab, enter 00000
Bob Umlas Excel MVP "Mike L." wrote: 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 |
|
#6
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
