+ Reply to Thread
Results 1 to 4 of 4

Excel-Format for Millions/rounded to 2 digits after the decimal point/Thousand seperator

  1. 06-14-2012, 05:30 AM #1
    Hitchhiker_Nürnberg
    Hitchhiker_Nürnberg is offline
    Registered User
    Join Date
    11-22-2011
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2003
    Posts
    6

    Question Excel-Format for Millions/rounded to 2 digits after the decimal point/Thousand seperator

    Hi,

    i have to know, how to define the excel format for the following request:

    Value (e.g.) = 2.458.312.123,12
    Target = 2.458,31

    Currently i use this format --> 0,,.00
    Result = 2458,31

    How to change the format to include the thousand separator ?

    Thanks

    Frank
    Reply With QuoteRegister To Reply
  2. 06-14-2012, 05:38 AM #2
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel-Format for Millions/rounded to 2 digits after the decimal point/Thousand seperat

    #,##0.00,,
    should do that.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  3. 06-14-2012, 05:46 AM #3
    npamcpp
    npamcpp is offline
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Excel-Format for Millions/rounded to 2 digits after the decimal point/Thousand seperat

    retreating and bowing to romperstomper's superior skills.

    Ich hab noch nie 'ne Antwort von romperstomper gesehen die weniger als 100% korrekt war. Da Du Deutsche Einstellungen benutzt, solltest Du alle Kommas gegen Punkte austauschen, und umgekehrt.
    Last edited by npamcpp; 06-14-2012 at 05:56 AM.
    Like a post? Click the star below it!
    Reply With QuoteRegister To Reply
  4. 06-14-2012, 06:02 AM #4
    Hitchhiker_Nürnberg
    Hitchhiker_Nürnberg is offline
    Registered User
    Join Date
    11-22-2011
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Excel-Format for Millions/rounded to 2 digits after the decimal point/Thousand seperat

    That works :-)

    Thanks ...

    Frank
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1