Excellent, just what i needed, thanks very much for your help.
--
RMP


"bj" wrote:

insert a column next to it
in C2 enter
=text(b2,"00 00000 000")
copy and paste to end of data
copy column c and paste special values
it is text that will show the same in the formula bar and the cell

"RMP" wrote:

I have a number showing in cell B2 as 00 00000 000 which is the format
required.

When I view the same number in the formula bar it shows as 0000000000 and is
sometimes even a digit short (removing the first zero)

The format showing is affecting my VLOOKUP formula, please could someone
help me by formatting the account number so it shows as 00 00000 000 in the
cell and in the formula bar.

Any help will be much appreciated.

Thanks
--
RMP