3 ms·

In excel, can you set the a column to not format to dates? I think you can do that in google docs for example. Why don't they do that?

• LatteLazy 6y ago
  It's actually worse. If you expressly set the format of a column to text, then put 01/01 in it, you still get Jan-01 and a field value of 46000ish.
  • komali2 6y ago
    That's horrible UX - why on earth is it that way?