3 ms·

and IIRC, datatype conversion made through excel formatting options. change cell display to get decimal :) fun

• mcbishop 3y ago
  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.