Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add characters to beginning of text
Does anyone know how to add characters to the beginning of numbers -
I have a list of numbers 51126 54889 53665 and I want 051126 054889 053665 I can't use the format cells, as I need the numbers to be text?? Thanks |
#2
|
|||
|
|||
Hi
With number p.e. in A1: =TEXT(A1,"00000") -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Natalie" wrote in message ... Does anyone know how to add characters to the beginning of numbers - I have a list of numbers 51126 54889 53665 and I want 051126 054889 053665 I can't use the format cells, as I need the numbers to be text?? Thanks |
#3
|
|||
|
|||
Natalie,
Select the cells you want tmodify, then run this code: Sub AddApostropheToRange() Dim CellToModify As Object For Each CellToModify In Selection CellToModify.Formula = "'0" & CellToModify.Formula Next CellToModify End Sub Hope this helps Pete "Natalie" wrote: Does anyone know how to add characters to the beginning of numbers - I have a list of numbers 51126 54889 53665 and I want 051126 054889 053665 I can't use the format cells, as I need the numbers to be text?? Thanks |
#4
|
|||
|
|||
if 51126 is ib a1 in B1 type
="0"&A1 copy this formula down Natalie wrote in message ... Does anyone know how to add characters to the beginning of numbers - I have a list of numbers 51126 54889 53665 and I want 051126 054889 053665 I can't use the format cells, as I need the numbers to be text?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing text files with mathematical characters | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Remove single text characters | Excel Discussion (Misc queries) | |||
How do I get rid of line feed characters in wrapped text? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |