Skip to Content
author's profile photo
Former Member

Decimal places in standard input schedule templates

Hi Gurus

I have created some input schedules using standard template. User here will be entering some values in 2 decimal places (like 1.25) but when I enter any values in the cells, it automatically round off the values and displays values without any decimal places.

I have tried changing the formats in Format control panel by changing the DATA / DEFAULT 's PATTERN / ALL for ROWs but it did not help.

Please help how to resolve this.

Cheers

Swathi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Apr 30, 2011 at 09:55 AM

    Hi,

    The dynamic templates in 7.5 NW are using EVDRE format. In that case, the format is basically defined by the format range. If you just change the format of the data cell, the format range will override. So, you need to change the format of the cells defined in formatrange.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Swathi,

      Could you please check the settings of Excel.

      Excel international setting is related to the display number format only. If you changed the decimal symbol from the regional

      setting of Windows, you should log off and log on to BPC Excel and try again.

      Regards,

      Sanjeev