G

#### Guest

have manually added a leading zero to some of the EIN's. The remaining EIN's

data have 7 digits. I want to add a leading zero only to the EIN's that have

7 digits.

If I use the following expression to update the EIN field will it ignore the

EIN's that have 8 digits or will it delete one digit so that it can add the

leading zero? Hence an EIN with 2 leading zeros. If my expression will not

work, how do I do this?

=RIGHT("00000000" & [EIN], 8)

Thanks for the help,