Feb 19 2020 01:14 AM
A colleague of mine opened an Excel spreadsheet exported from SAP.
One column contains numbers only, but is recognized as text.
She does not see the regular green triangle in front, neither the yellow icon with an exclamation mark that gives you some options as to e.g. "convert to number" or "ignore error". We know how to resolve that through a formula, but it's cumbersome.
She mails the file to me, and while we both have the same company standard setup I see those two marks that tell me that I need to convert.
How come that the two variants act differently?
Is there any way we can force it to show those marks when missing? It's so more easy to convert!
BR
Kai B Isnes
Feb 19 2020 01:23 AM
Feb 19 2020 05:27 AM
Hi @kaibisnes,
These steps might be helpful.
File > Options > Formula - Error Checking Rules
Make sure the option is checked "Numbers formatted as text or preceded by an apostrophe"
Regards, Faraz Shaikh, MCT, MIE, MOS Master, Excel Expert