Forum Discussion
Column entries not lining up when under 'show formulas'
I have a large spreadsheet and some of the data is throwing an error. When under Formulas >show formulas > this is my view: The format is set to number, the alignment is correct, so I'...
1. What does it look like when NOT in formula view?
2. Which are "off" according to you, the ones that are centered, or the others?
2. Which are "off" according to you, the ones that are centered, or the others?
- 1. When not in formula view, all entries line up, centered. (I have that selected in alignment)
2. The ones that are 'off' are those with the red arrow in the picture, left alignment, sorry its small.
I've also checked and looked into the Data> text to columns and that did not change the error. It appears those that are aligned to the left, will not create an output for the formula I am trying to use as well.
