leading numbers

  1. C

    Leading Zeros insert

    Hi I am new to this board and have tried every solution to inserting leading zeros. My question is how to insert leading zeros to the following cell entry? 206A 206B 206C 206T I have tried the format function but this does not work due to the fact I have a letter on the end of the cell...
  2. Ozhatch

    Add characters to numbers in cells

    I have a list with three columns of telephone numbers - some 200 numbers in all. To facilitate dialing an international number directly from the cells, I need to add '+64 to the beginning of each number. e.g. 98294578 becomes '+6498294578. (The ' sign is so that the cell doesn't see the + as...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top