5 ms·

I'm pretty sure that modifying a cell's number format never affects the underlying value.

• agumonkey 3y ago
  maybe not the actual memory data, but AFAIK it does affect the behavior of other logical / arithmetic functions in strange ways
  • deleted 3y ago
    [deleted]
  • mcbishop 3y ago
    Okay, thanks. If this is correct... it's unsettling and not cool.
    • doubloon 3y ago
      there are excel parsing libraries will treat the underlying data differently depending on how it is formatted. operations people basically have to do workarounds for this all the time.