Skip to main content
Nintex Community Menu Bar

Drawloop - Formatting Currency In Excel

  • Feb 15, 2022 10:15 AM UTC
  • Aug 5, 2026 10:23 AM UTC
  • 0 replies
  • 123 views
  • Translate All

KB_Admin
Nintex Employee
Forum|alt.badge.img+8

Topic

How to format a cell in Excel for Euro currency.

 

Instructions

In Excel, use the formula =SUBSTITUTE(TEXT(A1, "€0.00"), ".", ",") with A1 being the cell that is pulling in the amount to be converted to the Euro.

 https://community.nintex.com/t5/How-To/Drawloop-Excel-as-middleware-Connected-Data-and-Named-Ranges/ta-p/120828