I have code retrieving data from firebird database, some value are stored as characters despite fact that they look like numbers. It is logic for given case as those are identifiers and no numerical operations are expected with those fields.

When I write them into Excel via openpyxl, Excel shows for each cell that annoying problem that something which looks like number is stored as text.

I tried to apply format on the cell via this code:

for row in ws.iter_rows(min_row=min_row,max_row=max_row,min_col=min_column,max_col=max_column): #(min_row=1, max_col=3, max_row=2):
for cell in row:
        if cell.column in (2,4,5,7): #Apply text format '@'
        cell.number_format = numbers.FORMAT_TEXT
        cell.value=cell.value

But no luck. Can you advice how to solve this? I mean practilly that silly message of Excel has no impact, it just make things slower because it is displayed for each cell one by one and also it looks weird.

Many thanks

Vladimir