4 Replies Latest reply: Jan 19, 2012 4:03 AM by khaleel shaik RSS

how to set correct number format

khaleel shaik
Currently Being Moderated

Dear sir

 

 

i am enter qty (example 100)ofter press enter  that time is showing 10.000,

 

how to set correct number format   in 100 qty

 

Edited by: khaleelkumar on Jan 18, 2012 11:49 PM

  • Re: how to set correct number format
    Jeevan Sagar
    Currently Being Moderated

    Your question is very generic. Where is this happening (TCode)?

  • Re: how to set correct number format
    Jürgen L
    Currently Being Moderated

    What is a correct format?

     

    a quantity field in SAP is defined with 3 decimals in general thru the field domain.

     

    hence, when you enter 1, then SAP adds the decimal separator and the 3 decimals after hitting enter.

     

    Based on the customizing of unit of measure the appearance can be controlled, but just the appearance, you cannot restrict to enter no decimals, even you dont display them

    • Re: how to set correct decimal number
      khaleel shaik
      Currently Being Moderated

      dear sir,

       

       

       

      i am type any number ofter enter  it is showing decimal points

       

       

      ex i am enter 100 it is showing 10.00.000

       

      how to rectify 100

      • Re: how to set correct decimal number
        khaleel shaik
        Currently Being Moderated

        Aaaaargh! This can be frustrating in reporting out of SAP into Excel: decimals are considered thousands separator or numbers are not recognized at all as a number. There are three settings involved. To properly solve this issue:

         

            first check what is the standard decimal figure used in your company. Then check if this is also used in SAP (System > User profile > Own data ).

            then check the regional settings of Windows (in XP look in Control Panel). The regional settings also determine the decimal settings. Make sure this is also in sync.

            finally check Excel options (Tools > Options ). Either use system settings or enter the figures manually.

Actions