Converting German number format to US style

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Converting German number format to US style

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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 ".".

User Tag List

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