Excel Features Ideas - Incorrect currency format in the Add-In for Excel in German

%3CLINGO-SUB%20id%3D%22lingo-sub-264121%22%20slang%3D%22en-US%22%3EExcel%20Features%20Ideas%20-%20Incorrect%20currency%20format%20in%20the%20Add-In%20for%20Excel%20in%20German%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-264121%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%0A%3CP%3EI%20created%20a%20table%20with%20some%20data%20in%20an%20Excel%20sheet.%20One%20column%20has%20its%20data%20formatted%20as%20currency.%20When%20running%20Ideas%2C%20the%20currency%20format%20is%20wrong%20in%20the%20Add-In%20task%20pane.%20It%20shows%20%24%20instead%20of%20%E2%82%AC%20and%20uses%20a%20dot%20as%20decimal%20separator%20instead%20of%20a%20comma%20(Germany).%20Inserting%20the%20chart%20however%20corrects%20this%20error%20and%20the%20format%20is%20ok.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54902iA8DA387A8193031B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-264130%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Features%20Ideas%20-%20Incorrect%20currency%20format%20in%20the%20Add-In%20for%20Excel%20in%20German%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-264130%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61451%22%20target%3D%22_blank%22%3E%40Mourad%20Louha%3C%2FA%3E%26nbsp%3B%3CSPAN%3E%20thanks%20for%20spotting%20this.%20We%20will%20follow%20up%20with%20the%20Excel%20Dev%20team%20on%20it%20and%20get%20back%20to%20you.%20Thanks!%20Staff%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MVP

Hi there,

I created a table with some data in an Excel sheet. One column has its data formatted as currency. When running Ideas, the currency format is wrong in the Add-In task pane. It shows $ instead of € and uses a dot as decimal separator instead of a comma (Germany). Inserting the chart however corrects this error and the format is ok.

 

image.png

 

 

Best,

Mourad

1 Reply
Highlighted

Hi @Mourad Louha  thanks for spotting this. We will follow up with the Excel Dev team on it and get back to you. Thanks! Staff