Feb 20 2021 03:13 AM
Feb 20 2021 03:26 AM
Enclosed Sheet and further down information on how to do it.
To cancel a selection of cells, click any cell on the worksheet.
Next to the selected cell or range of cells, click the error button that appears.
On the menu, click Convert to Number. (If you want to simply get rid of the error indicator without converting the number, click Ignore Error.)
This action converts the numbers that are stored as text back to numbers.
Once you have converted the numbers formatted as text into regular numbers, you can change the way the numbers appear in the cells by applying or customizing a number format. For more information, see Available number formats.
The file has been corrected as required.
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here