Excel default format as Accounting (Not sure why) RRS feed

  • Question

  • All my new entries are defaulting as Accounting (putting a $ format to any number)

    I am not sure how this occurred, or how to correct it.  Any ideas?
    Tuesday, July 29, 2014 8:55 PM


  • Hi Mark,

    I suggest you checking the format of cell whether it was set to accounting or a custom one. If yes, I suggest you changing the format to general like figure below:

    Does this issue occur in a new workbook? If yes, I suggest you repairing or updating the Office application to see whether this issue was fixed.

    Best regards


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Mark Matzke Wednesday, July 30, 2014 8:05 PM
    Wednesday, July 30, 2014 8:58 AM