That will neither correct the original number in-situ nor address a number formatting issue - it will only work with numeric text. It also won't work with numeric text numbers less than 1000 or greater than 999999.99
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|