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.)
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 fromopenpyxl
, strings ended in0
(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.)