add zeros to number

D

dlb1228

i have a number and want to convert it to a text field and add HE and zeros
so all numbers are 12 digits. For example
Start end

1234 HE0000001234
45399 HE0000045399
339987 HE0000339987
 
M

MGFoster

dlb1228 said:
i have a number and want to convert it to a text field and add HE and zeros
so all numbers are 12 digits. For example
Start end

1234 HE0000001234
45399 HE0000045399
339987 HE0000339987
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format(1234,"\HE" & String(12,"0"))

The H has to be escaped "\" to avoid confusion w/ the Hexadecimal
indicator.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ/zr7oechKqOuFEgEQKN/gCggvz99LHVL8XyFmoEd/ja2ss0EVIAniJW
ce1RAu/olV0CpAZKviEkrYAi
=vRJa
-----END PGP SIGNATURE-----
 
Top