openpyxl icon indicating copy to clipboard operation
openpyxl copied to clipboard

OpenPyxl understands big number strings ending in 0 as float

Open JPTIZ opened this issue 2 years ago • 0 comments

I have a few sheets containing phone numbers, and some are written without the proper format (e.g. 10912345678 instead of (10)91234-5678). When I load the sheet from openpyxl, strings ended in 0 (e.g. 10912345670) are read as float (1091234567.0) instead of an integer or simply leaving them as strings.

(I'll provide more details/example, just opening quickly so I don't forget about it later.)

JPTIZ avatar Feb 11 '23 15:02 JPTIZ