Text rather than general
Been there, done that.
Sometimes Excel insists it knows better what the formatting should be, even for TEXT cells (for instance, and as far as I can remember, date in a text cell).
Only way to go is with the apostrophe..
(of course I expose the programmer point of view using Excel to import/export data, not when you write down your expenses of the week by hand)
Biting the hand that feeds IT
