SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 45359: Number formatting styles might be ignored in SAS® Financial Management reports or data-entry forms

DetailsHotfixAboutRate It

Number formatting styles might be ignored in a SAS® Financial Management data-entry form or read-only report when using a non-English version of Microsoft Excel.

For example, using Microsoft Excel 2007 French Version, create a SAS Financial Management read-only report. In the SAS Solutions ribbon, select Members->Format Members.  Next, select 'Set Style'  and then select 'Percentage.'  Click OK.  The cell format does not change.

If you encounter this problem, follow the instructions in SAS note 19486 (http://support.sas.com/kb/19/846.html) to enable the SAS Add-In form Microsoft Office (AMO) log and reproduce the problem.  An error similar to the one below might be displayed in the AMO log.

	Impossible de trouver le style 'Percent'.

For additional information please contact SAS Technical Support.

 



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementWindows Vista for x645.25.39.2 TS2M29.3 TS1M2
Windows Vista5.25.39.2 TS2M29.3 TS1M2
Windows 7 Ultimate x645.25.39.2 TS2M29.3 TS1M2
Windows 7 Ultimate 32 bit5.25.39.2 TS2M29.3 TS1M2
Windows 7 Professional x645.25.39.2 TS2M29.3 TS1M2
Windows 7 Professional 32 bit5.25.39.2 TS2M29.3 TS1M2
Windows 7 Home Premium x645.25.39.2 TS2M29.3 TS1M2
Windows 7 Home Premium 32 bit5.25.39.2 TS2M29.3 TS1M2
Windows 7 Enterprise x645.25.39.2 TS2M29.3 TS1M2
Windows 7 Enterprise 32 bit5.25.39.2 TS2M29.3 TS1M2
Microsoft Windows XP Professional5.25.39.2 TS2M29.3 TS1M2
Microsoft Windows Server 2008 for x645.25.39.2 TS2M29.3 TS1M2
Microsoft Windows Server 20085.25.39.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 for x645.25.39.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 Standard Edition5.25.39.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition5.25.39.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 Datacenter Edition5.25.39.2 TS2M29.3 TS1M2
Microsoft® Windows® for x645.25.39.2 TS2M29.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.