Question:
Hello everybody,
When running a query all results appears in text format, NOT in a custom format like ("$" # ##0.00). If I explicitly change something in selected cell, format applies correctly.
In Excel 2000, XP all works fine. All settings for Analyzer setted on defaults on all Excel versions.
BW version: 3.0B Patch 8 3020.8.610
Any suggestions will be appreciated.
Thanks.
Answer:
Your support pack (SP 8) is quite old. I'd try applying a recent patch and SAP GUI.
Answer:
Just found the solution.
I've changed in Regional Settings standards and formats to English and default location to United Kingdom (old one was French / France). Now it works fine for me