Skip to Content
avatar image
Former Member

Changing number format

Hi ,

I need to change number format . for example if its 1 lakh 1,00,000.56 (56 paise) its displaying as

1.00.000,56.

how to convert it to 1,00,000.56

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

12 Answers

  • avatar image
    Former Member
    Feb 16, 2009 at 10:09 AM

    Change the Decimal Notation in Defaults Tab of Tcode SU3.

    Regards,

    Jinson

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:07 AM

    go to su01 and change

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:07 AM

    Hi,

    GOTO(Menubar)>System>User Profile>own data>Parameters tab

    Or:SU01

    Regards,

    Gurpreet

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:08 AM

    hi...

    THIS IS TESTED CODE....

    DATA: W_CHAR(50).

    WRITE <FIELD> TO W_CHAR.

    WRITE: / W_CHAR.

    REGARDS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:09 AM

    hello

    CURRENCY_CONVERT this FM

    Thnak u,

    santhosh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:10 AM

    Number format depends on your personal settings. You can change it by going to tcode SU01 and editing your profile or by following the path in the SAP menu System -> User Profile -> Own data and from there to Defaults tab.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:11 AM

    hi,

    is there any option other than su01. since i suggested su01 but its not been accepted since notation will vary server server . kindly suggest me solution other than su01.

    Thanks,

    divya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:12 AM

    Hello,

    Just check whether 'Fixed Point Arithemetic ' (Attributes->Fixed Point Arithmetic ) is checked or not, if it isn't then you may face this kind of problem.

    Thanks: Zahack

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:23 AM

    Hi,

    It'll solve ur problem.

    v_1 = '1.00.000,56'.

    TRANSLATE v_dat1 USING '.,,.' .

    U'll get v_1 = '1,00,000.56'.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 10:29 AM

    Hi,

    In Menu:- System --->User Profile --->Own data and there the ---> Defaults tab

    This will definately help.

    Please let know if i am wrong

    Thanks and regards

    Suraj

    Add comment
    10|10000 characters needed characters exceeded