Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

To change the decimal display in a SAS Financial Management Read-only report or Data-entry template, open the report/template in Microsoft Excel and select a cell of the type you want to change, such as a data-entry cell.

• For Excel 2003: On the Excel menu bar, select Format > Style and the style box should appear with "SAS FM writeable data cell" selected (for a data-entry cell). Choose 'modify' and change your decimal place selection from 2 to 0.


• For Excel 2007: From the 'Home' option on the Excel menu bar, select Styles > Cell Style and the style box should appear with "SAS FM writeable data cell" selected (for a data-entry cell). Click your right mouse button on the cell style, choose 'modify'. In the Style dialog, select 'Format' and change your decimal place selection from 2 to 0.

Note that you will also need to do this for the Read-only cells in a Read-only report. Save the template after the formatting has been modified.

For information on setting precision in SAS Financial Management reports, please refer to SAS Note 30707.

Operating System and Release Information