Today is going to help a friend to write a small program with excel, but encountered a problem, his some cell in a table is a digital format, some is text format, as shown in figure:



I use openpyxl processing XLSX format, I want to uniform format for digital format
I have tried to use during
Cell. Style. Of number_format. Format_code='0.00 e+00'
Or
Cell. Of number_format='0.00 e+00'

But they are wrong, could you tell me which bosses know how to deal with?

CodePudding user response:

Resolved:
Cell. Of number_format='0.00'

CodePudding user response:

" post it for you,

CodePudding user response:

refer to the second floor old coconut response:

" stick it for you,

CodePudding user response:

As 36.3 ° transformation is not