Posted 13 August 2018, 6:48 pm EST
I have a column in my spreadsheet which contains text which may or may not contain a number and the length of the text is not known. We do not want excel to convert this to a number in those instances and strip leading zeros, so I need to set the formatting number category to “Text” as you can in excel. How can I do that? I can only seem to set a custom format, which doesn’t give me what I need.