Ok, so increasingly strange. I looked back at the PDFs for previous years,
and it looks like the numbers have been marching across the cell towards the
right for 3 years, after having started off on the left.
I've reset the base spreadsheet and this year's to zero indent, and made a
note. We'll
Interestingly, the base spreadsheet that I copy and edit, has an indent of
193 pt, 30 pt less than this one. The one for 2020 has an indent of 53 pt,
and rather than being to the right, where I wanted the numbers to be,
they're somewhere to right of center. I don't have 2019 any longer, or I'd
Oh, wow! Good catch! I don't know how that happened, since I didn't
deliberately do that.
I'll also try out your formula suggestion. Thanks!
Any idea how that indent could have slipped in there? I know for sure I
didn't put it there.
--
Sent from:
Hi Regina,I found your issue: the indent on your cells (like F3) is
223pt which places the text more or less 3 inches (7.9cm) to the right
of the cell. This seems to be something that was done as formatting to
the cells individually because the Default style calls for a zero
indent. Looking at
Hi,It is a bit hard to guess what is going on without actually seeing
the file. Can you e-mail it to me?Two things come to mind:-
Calculations are in manual mode and the cells are not re-calculated.
You can see the status in Data > Calculate (or try F9 to force
recalculation)- Conditional