excel

  • Thread starter Thread starter semb1960
  • Start date Start date
S

semb1960

how do i add a 0 in front of an existing range of numbers, I have a phone
system that has a lot of speed dials, the numbers will only work if there is
a 0 at the start of each number. Wat too many to do one at a time.
Can anyone help with this one?

Cheers
 
how do i add a 0 in front of an existing range of numbers, I have a phone
system that has a lot of speed dials, the numbers will only work if there is
a 0 at the start of each number. Wat too many to do one at a time.
Can anyone help with this one?

Cheers
Click to expand...

Hi ,

Arrange the data in a Column.Eg - in column A.
If your data is in A1 Just enter -

="0"&A1

You can copy the same till the end.

Thanks
Thyag
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting specific information 3
expanding SUMPRODUCT 1
Dialer.exe - I am actually trying to get dialer.exe to dial Excel cell phone numbers. I am using Exc 1
Dim IndxNum As Long & Dim c As Variant 7
Code works but goes into endless loop and crashes 1
Counting Criteria Values with For Loop 3
Eliminate blank row at top of Text Box entries 3
Optional argument as Variant not acting like number 4

Back
Top