On Jun 26, 9:06 pm, "NickHK" wrote:
Or use rng.Text instead, then no formatting required.


rng.Text solved the whole problem! Thank you, Nick.

JMB:

Thanks for pointing out the string return from Format. I totally
missed that, and it would then make sense that putting it into a
numeric variable would change it back. I think remembering that may
save me some hours of frustration down the road!

Thanks to both of you for helping.
Ed