Hi Chris, Thanks for the info. If I right click on the green mark, that
brings up a warning triangle in column C. If I then right click on the
triangle, I get options to "convert to number". If I select that, the
green mark disappears. It seems the green mark only happens when there is
a single number in column D and for some reason this is being read as
text. I did as you suggested regarding checking the format for the column
and it is definitely set to General.
I could go through the entire year and get rid of each green mark line by
line (its not on every line) but that would be quite tiresome. What do you
think?
Regards, Christine.
On Sun, Dec 12, 2021 at 5:04 PM Chris Shepheard <
chris.shepheard@xxxxxxxxxxxxxxx> wrote:
Hi Christine,
It doesn’t matter which order the negative numbers are in so long as they
go with the relevant negative as they will be sorted into the correct order
in the database. Re-arrange or leave whichever is easiest for you.
I suspect those dates/numbers in column F are actually the date the
negative appeared. Probably best to put them in column H (that held
publication date and size in the earlier index books but the column was
omitted when the new system books were printed). The way to reformat a
column to accept anything, though, is to right-click on the “F” at the
column head and select “Format cells”. From the list that appears ensure
that “Text” is selected – that will ensure that Excel lets exactly what you
type in appear (it won’t try to divide 3 by 12 as in your example.
I suspect the green corner is nothing to concern us but, considering the
problem with 3/12, I suspect the formatting of parts of your spreadsheet
may have got changed inadvertently and that could be causing the green
mark. Clicking on the green mark may offer some options/choices that are
probably not relevant for our needs. Try right clicking on the “D” column
header and seeing what is set in “Format cells”. It should be “General” I
think (at least it is in my template copy) and if you select “General” (if
it isn’t already set to that) to see if the green marks disappear.
Let me know if any of that works or you have further problems.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx
*From:* heraldnegindex-bounce@xxxxxxxxxxxxx <
heraldnegindex-bounce@xxxxxxxxxxxxx> *On Behalf Of *Christine Callow
*Sent:* 12 December 2021 14:02
*To:* heraldnegindex@xxxxxxxxxxxxx
*Subject:* [heraldnegindex] Re info out of order etc
Hi Chris, In November 1999 some of the entries are out of order in terms
of the negative numbers - shall I just type them as seen?
Also I am coming across a few entries for column F which read something
like 3/12 or similar. Every time I try to type them in, it doesn't work.
Is there an easy way to format column F to accept numbers/fractions?
Also FINALLY, when I enter a single number in column D (the negative nos
column) I get a green mark appear in the top left hand corner of the line.
I haven't the faintest idea how to remove it. Does it matter?
Regards, Christine
