Results 1 to 2 of 2

Thread: [RESOLVED] Problem with number format.

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [RESOLVED] Problem with number format.

    I have one workbook which all of a sudden started showing numbers displayed as 254-789 rather than 254,789. My default language is English and my regional setting is English (United States). When I try to format the cell it treats it as if it is some kind of negative number.
    Name:  2020-07-31_14-33-24.png
Views: 115
Size:  75.9 KB

    I've attached a workbook which is the result of copying some of the data from the problem workbook.

    Does anyone have any suggestions to fix it? Recreating the workbook would be very difficult.
    Attached Files Attached Files

  2. #2

Posting Permissions

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



Click Here to Expand Forum to Full Width