Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Random Custom Number Formats Showing Up in Excel 2016, Why?


  • Please log in to reply
No replies to this topic

#1 Lxno78

Lxno78

  • Members
  • 51 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:11:03 PM

Posted 05 August 2016 - 09:49 AM

So working with custom formats for cells (under Right Click Cell > Format Cells...> Number Tab > Custom), Excel will list a few default custom formats like this (I'm talking about the right side that starts with General, 0, 0.00, etc.). When I enter my own custom formats  they will appear at the bottom of the list.  I'm noticing Excel adding random formats to this list, about several minutes or more after I start a workbook. If I close Excel and re-open it the random formats are gone, but they sometimes return after working on the workbook for some time.  Right now these are the five formats that are consistently appearing without me entering them:

  • "Yes";"Yes";"No"
  • "True";"True";"False"
  • "On";"On";"Off"
  • [$€-x-euro2] #,##0.00_);[Red]([$€-x-euro2] #,##0.00)
  • 00000

They don't show up in this list when I start Excel, so I know they aren't default custom formats and I'm not adding them in myself. I wasn't even using formulae in one of my workbooks and they appeared, so even if a formula caused Excel to automatically generate a custom format, I'm still experiencing the problem even when I haven't used a single formula on a workbook.

 

What is going on with this?


Edited by Lxno78, 05 August 2016 - 10:05 AM.


BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users