Hi,

I suggest formatting the cell. Format - Cells - Number - Customr. In
the text box change the format to 0000000 (to indicate 7 digits).

Regards,
A

"jeanette.rimmer" wrote:

Hi, Im trying to insert 00 to the start of a number so that 98765 becomes
0098765, Ive set up a concatenate but for some reason this only works in the
first cell

=CONCATENATE($E$1,C2) where e1 contains 00.

When I copy this down the sheet I only get the number in the first column,
however when I then go and double click in the cell the formula updates and
gives me the correct answer

Any ideas?

Thanks