2 ms·
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.
by pintxo 5y ago
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.
- bombcar 5y agoExcel loves replacing phone numbers with 12031041e8 or whatever when importing CSV. So useful.
- dylan604 5y agoThis 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.
- hermitdev 5y agoWhat'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.