Set Character Lengths

[carlos]

I have a column of data that has data like so:

5
050
75
0007


I am trying to convert these into:

005
050
075
007

Thank you in advance.

 

[Frank Kabel]

Hi Carlos
one way
=TEXT(A1,"000")
copy down (if column A stores your data)

HTH
Frank

 

[Norman Harker]

Hi Carlos!

Depends upon if you want them as numbers or text. At present it looks
like they may be text.

Keeping as text you need a helper column

=TEXT(A1,"000")

Once you have your data as you want it you can use:
Copy
Edit > Paste Special > Values > OK
Then remove the original data

Converting to numbers:

Copy a blank cell
Select the range
Edit > Paste Special > Add
Format > Cells > Custom
000
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.