Results 1 to 2 of 2

Converting German number format to US style

This is a discussion on Converting German number format to US style within the Excel Questions forums, part of the Question Forums category; I have some users in Germany who have German regional setting on their PC's. As such the number format in ...

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    1

    Default

    I have some users in Germany who have German regional setting on their PC's. As such the number format in Excel is German - the thousand seperator is a . and decimal seperator is a , (e.g 999.999,99 instead of 999,999.99)

    Is there any way that this format can be converted to a standard US format without having to change the regional setting to US ??

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    Use the Data | Text to Columns... menu command. At Step 3 of 3 press the [Advanced...] button and set the Decimal separator to "," and the Thousands separater to ".".

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com