Results 1 to 3 of 3
  1. #1

    Custom format in XP (OfficeXP)

    I am trying to do a custom format that looks like this
    It works correctly except always adds a zero as the last digit on the last numper of the last group of 4 digits no matter what is typed.
    Any suggestions?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Custom format in XP (OfficeXP)

    I think that your problem is that the format is for 16 digits and the largest number that Excel can handle as a number is 15 significant digits. Therefore, I believe that you will find that the low order digit that you entered has been replaced by zero. If this number does not have to be used for calculation, then I would suggest that you enter it as text with the formatting included in the text.
    Legare Coleman

  3. #3

    Re: Custom format in XP (OfficeXP)

    That makes sense. I will try a workaround . Thanks


Posting Permissions

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