Hi Christine,
Please just ignore the green mark – obviously Microsoft trying to be too clever.
It doesn’t matter because none of that is exported to the database as I just
extract the data as a Comma Separated Value (CSV) file which is pure text with
commas inserted to differentiate each field.
That is dropped straight into the database management software. If eventually
different database software is selected for the project, it too will only
import the CSV files so none of the Excel formatting will be carried over.
Thanks,
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
On Behalf Of Christine Callow
Sent: 13 December 2021 15:03
To: heraldnegindex@xxxxxxxxxxxxx
Subject: [heraldnegindex] Re: Re info out of order etc
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 <mailto: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 <mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From: heraldnegindex-bounce@xxxxxxxxxxxxx
<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx
<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx> > On Behalf Of Christine Callow
Sent: 12 December 2021 14:02
To: heraldnegindex@xxxxxxxxxxxxx <mailto: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