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

Question

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 Mode

Microsoft Document shows below function is able to Excel 2016.Can't found in Excel 2016.Can't found in Excel 2016.

Can't found in Excel 2016.

Answer 1

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.

---