Microsoft Office Professional 2016 ASC() and BIG5() function not found

Alias Leung 20 Reputation points

My office version is Microsoft Office Professional Plus 2016. I found some website said that need to enable the developer mode. However, My excel can't found the ASC and Big5 function even enabled the developer mode.

Excel Result


Developer Mode991fca89-66e6-44c6-9083-69552d1becf9

Microsoft Document shows below function is able to Excel 2016.Can't found in Excel 2016.Can't found in Excel 2016.8a3b7fe3-4bf7-422a-86ae-95769e72b52f

Can't found in Excel 2016.


A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,439 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,526 Reputation points

    Hi @Alias Leung

    Based on my tests, Excel for Office Professional Plus 2016 does not support BIG5 function and supports ASC function for specific language, such as Chinese Simple , likes the following image.


    Under the case of using Chinese Simplified, if you need to change half-width (single-byte) characters to full-width (double-byte) characters, I suggest you try WideChar function.


    Here is a similar thread "Cannot find ASC / BIG5 formula in Excel 2016", you may also have a look.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful