Jun 26 2022 09:03 PM
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
Jun 26 2022 10:37 PM - edited Jun 26 2022 11:03 PM
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 '
Jun 26 2022 10:43 PM
@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"