Set Openpyxl Cell Format to Currency

Sophia Al-Mansoor
Sophia Al-Mansoor
• • 1 min read

I'm Creating an Excel Sheet Using Openpyxl. Some Cells Represent Monetary Values. How Can I Change the Format of a Cell to Be of Type "Currency", I. E. I Want...

Set Openpyxl Cell Format to Currency

I'm creating an excel sheet using openpyxl. Some cells represent monetary values. How can I change the format of a cell to be of type "currency", i.e. I want a "€" symbol to be displayed after the number.

2

1 Answer

Try setting the format code with your desired format code

_cell.number_format = '#,##0.00€'
4

Must Read

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Sophia Al-Mansoor

Sophia Al-Mansoor

Global Business & E-Commerce Reporter
Linkedin Twitter

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.

Share this article
Twitter Facebook Pinterest