| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cvt number to character
Hiow can I convert a column of numbers from numeric to character and pad with
2 zeros e.g. I want the number 1 to appear as character 001 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cvt number to character
Select cells
Use Format | Cells; open Custom tab Enter 000 If you wish you could then format | align | left best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "GKW in GA" wrote in message ... Hiow can I convert a column of numbers from numeric to character and pad with 2 zeros e.g. I want the number 1 to appear as character 001 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cvt number to character
=text(A1,"000")
"GKW in GA" wrote: Hiow can I convert a column of numbers from numeric to character and pad with 2 zeros e.g. I want the number 1 to appear as character 001 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cvt number to character
Place in a helper column:
=TEXT(A1,"000") Copy/paste special - values in the Helper column "GKW in GA" wrote: Hiow can I convert a column of numbers from numeric to character and pad with 2 zeros e.g. I want the number 1 to appear as character 001 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is the first character a number or letter | Excel Worksheet Functions | |||
| Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
| Number of character in one cell. | Excel Worksheet Functions | |||
| remove cr character from a + number and change number to - 159cr | Excel Worksheet Functions | |||
| Why does last number of a 16 character number always change to 0? | Excel Discussion (Misc queries) | |||
Linear Mode
