Hello

Many thanks for that.

it works a treat.

"Edward" wrote:

On May 8, 8:00 am, bollard wrote:
Hello

In a spreadsheet containing UK phone numbers, all numbers should begin with
a zero, but when we pull off a report and copy and paste it into Excel,
depending on what's been input at source, some of the entries lack the zero.

Is there a way of formatting the column so that, if no zero appears at the
start of a phone number, one can be inserted at the start of each number?

Thanks.

If your number is of fixed length (say xxxx-xxxx) you can format like
the following:

Format-Cells-Number-Custom-0000-0000

This will turn the number 1234567 into 0123-4567.