Skip to main content
Nintex Community Menu Bar

Drawloop - Formatting Currency In Excel

  • February 15, 2022
  • 0 replies
  • 118 views

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