Re:Microsoft Exchange stops passing mail due to bug on 1/1/22
by pintxo on Saturday January 01, 2022 @10:11AM
(#29758970)
Lots of phone numbers start with a zero, converting string to numbers will most likely change the phone number by removing the information of the leading zero. Doing this in js will store it as base 8. Neither will make anyone happy.
[ Parent
| on HN ]
Re:Microsoft Exchange stops passing mail due to bug on 1/1/22
by bombcar on Saturday January 01, 2022 @10:16AM
(#29759039)
Excel loves replacing phone numbers with 12031041e8 or whatever when importing CSV. So useful.
Re:Microsoft Exchange stops passing mail due to bug on 1/1/22
by dylan604 on Saturday January 01, 2022 @10:48AM
(#29759450)
This is one of the most annoying things to me about Excel (of a long list). In pretty much every time MS applications feel they are smarter than me ends in MS application being wrong. It doesn't matter if the data is manually typed or pasted from else where, when Excel tries to auto-guess how to set the formatting of the cell is just horrid. Dates are shite when trying to be in the US and using UK formatted dates.
Re:Microsoft Exchange stops passing mail due to bug on 1/1/22
by hermitdev on Saturday January 01, 2022 @11:53AM
(#29760187)
What's even worse is if you inadvertently save the CSV with the auto format, the data will be lost, too. Excel is both a wonderful tool and the bane of my existence when dealing with financials.