Thank you both. This is perfect, I've never done much with the custom formatting and had no idea that is how this would work. I didn't even know that you could put the "m" in the formatting and not screw up the number.

I tell you, just when I think I'm starting to know Excel fairly OK, something basic like this comes along and I realize I've been making my job much harder than it needs to be for the last 5 years.