Help- Need to add 00 and ;

  • Thread starter Thread starter NewGuy
  • Start date Start date
N

NewGuy

Can someone help me out.

I have number like this:

00123456789

but I need to paste like a 100 number like this on an excel sheet and
add

00 (2 zeros) to the begining of the number and ; (semi-colon) to the
end of each number. These numbers will be pasted in a column format.

Is there a formula that I could use to speed this up instead of
entering each zero and semi-colcon one by one. I would appreciate any
help.

Thxs,

NewGuy :confused:
 
To add leading two Zeros
you can format the cells range as
Custom
in the Input box Type ( 00# ) then OK

any number you enterd in any cell of the range you have formatted will
be leaded with two Zero

for ; Sorry :( :(
 
To add the ; to your numbers you can use CONCATENATE as follows:

=CONCATENATE(A1,";") where A1 is the first cell containing the number
then drag this formula down

Pau
 
thnks -_Paul_Sheppard_-


Ok, I tried the following:

In Colm A input your original values
in Colm B use the Function *CONCATENATE * as follow
=CONCATENATE("00";A3;";")


because my 1st reply will not show 00 with this function
Hope this will help
 
Back
Top