Set Character Lengths

  • Thread starter Thread starter carlos
  • Start date Start date
C

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.
 
Hi Carlos
one way
=TEXT(A1,"000")
copy down (if column A stores your data)

HTH
Frank
 
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.
 
Back
Top