+ Reply to Thread
Results 1 to 8 of 8

Strange Currency Display 1000,0,00 instead of 1000,00

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    Spain
    MS-Off Ver
    Office
    Posts
    4

    Strange Currency Display 1000,0,00 instead of 1000,00

    Hello,
    When I format a cell to Euro and other currencies it displays the number as follows: 1000,0,00 instead of 1000,00

    or $1000,0,00 instead of $1000,00

    I cannot understand where the extra , come from. I have searched advanced setting and it does not help.

    Thank you in advance for your help.
    Alan

  2. #2
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    Re: Strange Currency Display 1000,0,00 instead of 1000,00

    If you right click one of the affected cells and select Format Cells, which entry under "Category" is highlighted?
    And if it's visible, what is written in the "Type" field?

    Beth.

  3. #3
    Registered User
    Join Date
    09-23-2019
    Location
    Spain
    MS-Off Ver
    Office
    Posts
    4

    Re: Strange Currency Display 1000,0,00 instead of 1000,00

    The category is Accounting and I do not have atype field, only symbol which is set to Euro

  4. #4
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    Re: Strange Currency Display 1000,0,00 instead of 1000,00

    Would it be possible to attach a desensitized version of the workbook?

    Beth.

  5. #5
    Registered User
    Join Date
    09-23-2019
    Location
    Spain
    MS-Off Ver
    Office
    Posts
    4

    Re: Strange Currency Display 1000,0,00 instead of 1000,00

    Unfortunately I cannot attach the file

  6. #6
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    Re: Strange Currency Display 1000,0,00 instead of 1000,00

    OK, then unfortunately I cannot assist further.

    Beth.

  7. #7
    Registered User
    Join Date
    09-23-2019
    Location
    Spain
    MS-Off Ver
    Office
    Posts
    4
    Quote Originally Posted by BanginMyHeadOnMyDesk View Post
    OK, then unfortunately I cannot assist further.

    Beth.
    Thank you for your help and time

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,648

    Re: Strange Currency Display 1000,0,00 instead of 1000,00

    If the reason that you are unable to attach the file is that the paperclip icon doesn't work please try the following instead: Click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 1000 and 10
    By tony h in forum The Water Cooler
    Replies: 21
    Last Post: 12-27-2015, 01:36 AM
  2. [SOLVED] 1000 hours display
    By Isaacadete in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2015, 04:50 AM
  3. [SOLVED] replace 1000 with nothing
    By ammartino44 in forum Excel General
    Replies: 7
    Last Post: 04-09-2015, 11:03 PM
  4. Replies: 5
    Last Post: 09-20-2011, 07:39 AM
  5. If a1 = 500 than 10, if it =1000 than 20 etc.
    By romettekitty in forum Excel General
    Replies: 4
    Last Post: 06-10-2009, 03:04 PM
  6. 1000+$K$5/1000 -what does $ indicate in formula
    By Coolbhims in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 07:55 AM
  7. How do I get entries over 1000 characters to display in a cell?
    By Mike in Berkeley in forum Excel General
    Replies: 3
    Last Post: 09-11-2005, 06:05 PM

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