Forum Discussion
Solved
Sum(Start Cell:End Cell) Not Working
Hey all - Just trying to sum some data in a spreadsheet I imported. Figure something must be set or wrong with the data, but cannot figure out what...? Any help appreciated. I have a column o...
The cells are seen as text.
Select them, then click Text to Columns on the Data tab of the ribbon.
Without changing the settings, click Finish.
The cells are seen as text.
Select them, then click Text to Columns on the Data tab of the ribbon.
Without changing the settings, click Finish.
Yay! Thank you! I had presumed that changing the format would work on text, such as changing "0" text to 0.00...as long as was a number, it would work, was the theory. Appreciated!