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'...
I ended up just copying and pasting onto another black document as values and then pasting as formatting. Still would like to know why that happened if anyone runs across it in the future!
- If you select the old values and press F5, special and then select either values or formulas (depending on what is in those cells) and then only check Numbers, what happen?
