Great work, KenJohn!
I'm curious though... Why would one want to mix formats on the same spreadsheet? It seems confusing -- Americans expect numbers to be in comma/decimal format and the French the opposite. I'm not sure what I'd do if I saw them mixed based on currency. (Well, I would assume there's an error on the speadsheet first off...)