News for hackers. Stuff that matters.
Re:Microsoft Fixes Excel Feature That Forced Scientists to R... by zeroimpl on Tuesday October 31, 2023 @08:46AM (#38083958)
> Remove leading zeros and convert to a number

This is stupid. If a leading zero was input, it was intended to be there and probably isn't a number. Been burned by this many times.

> Keep first 15 digits of long numbers and convert to scientific notation

This is stupid. If scientific notation was intended, somebody would have input it that way. This unnecessarily discards data. Been burned by this many times.

> Convert digits surrounding the letter "E" to a number in scientific notation

This actually makes sense I think?

> Convert continuous letters and numbers to a date

This is fairly stupid - dates ought to have delimiters between things (and a year!). Been burned by this a few times.

There are no comments on this comment yet.