Display SAP Minus keyfigures correct in Excel

Unfortunately, SAP export negative numbers like "Number-":

Excel minus figures display
Excel minus figures display

So you can work with this numbers, they must be changed to the format "-Number". This can be done either by hand, which is very elaborate for a large list or you can use the following Excel formula:

 

=MAX(C1;-SUBSTITUTE(C1;"-";""))

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0