Forum Discussion
Solved
SUMIF on Numbers formatted as text
Hi, I have something funky going on with my SUMIF statement. I have a table with a column of numeric codes which I have set the datatype to TEXT. My other table column has a count. I want to sum bas...
Hi again,
Since I have 100's of these I found one way to mass insert an apostrophe is to use the VBA macro option found in this link: https://www.exceldemy.com/add-leading-apostrophe-in-excel/ since it was the only way I could get the prefix apostrophe that is hidden and is flagged as 'Number formatted as text' warning, which I want for XLOOKUPs.
I set the data type back to General, ran the macro on the column, and voila, the SUMIF works.
Thanks to everyone for their help
Sue
Hello I was given this code to break into text. Can someone convert it to text. mog mmm mmm moo gi mod mmm mmh mmo mot