I have cell that contains a number with a custom format of 0000. If
there is a 1 in the cell then it displays 0001. I use the value in
that cell and when I update an Access table. When it is inserted into
the Access table it comes across as 1 instead of 0001. I have tried
changing the format in the access table but it doesn't make a
difference. I need it to go as 0001. How can I do this?

Thanks