Forum Discussion

tuanng47's avatar
tuanng47
Copper Contributor
Jun 27, 2022

Excel formular error

Dear all,

I have and error in formula and the error box appear as below.

However I can't edit my formula to fix the issue. I also can't save or close or undo my excel.

Anyone pls help me with this issue.

Thanks 

Tuan

excel

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jun 27, 2022

    tuanng47 What exactly are you trying to do here?

    The "+" in the beginning tells Excel to expect a formula. Perhaps you want to return a text string exactly looking like that. Then enter an space or apostrophe in front. Or enter ="+82:82B865:103"

     

  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    MCT
    Jun 27, 2022

    Hi tuanng47 

     

    To cancel and leave the formula just press Esc on the keyboard.

    What do you want your formula to do?

    If you want to write the text as it appears , you can just add single quotation at the beginning  '

     

     

Resources