+ Reply to Thread
Results 1 to 4 of 4

Number Format problem

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    Turkey
    MS-Off Ver
    Excel 2003
    Posts
    2

    Number Format problem

    Hello everyone,

    I am trying to find proper format for numbers but I am stucked.
    Is there any single format that contains two different formats below.

    For the two example below I am using #.### as format and It works
    No Format: 432756 Formatted: 432.756
    No Format: 432756,00 Formatted: 432.756

    For the below I am using #.##0,00 as format and It works.
    No Format: 62, 324 Formatted: 62,32
    No Format: 62,00 Formatted: 62
    No Format: 0,43543 Formatted: 0,43

    Thanks

  2. #2
    Registered User
    Join Date
    04-16-2012
    Location
    Turkey
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Number Format problem

    Is there any single format that contains the two situation above?

  3. #3
    Forum Contributor
    Join Date
    03-22-2012
    Location
    OR, USA
    MS-Off Ver
    Excel 14/2010
    Posts
    273

    Re: Number Format problem

    #.##;0,00
    use custom formatting

  4. #4
    Forum Contributor
    Join Date
    03-22-2012
    Location
    OR, USA
    MS-Off Ver
    Excel 14/2010
    Posts
    273

    Re: Number Format problem

    Did this resolve your issue?

    Please mark as SOLVED if yes. And don't forget to hit the STAR under username if my answer was helpful.
    Last edited by lloydgodin; 04-18-2012 at 04:39 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1