That does indeed prevent Excel from reformatting numbers into dates, but it also destroys the rest of the format and all text gets cramped into a single cell or awkwardly stretched with lots of empty cells between. Format is okay, I just don't want any no reformatting.
Thanks anyway, though. I guess there's just no way to turn off that stupid date formatting.
|