Message:

<p>[QUOTE=&quot;Just Carl, post: 353835, member: 4552&quot;]Back to your Excel Work sheet. My suggestion is to enter a date and mint mark for all coins in the collection regardless of if you have them or not. Now leave the grade column empty to indicate you do not have that coin. This way you have a list of all the possible coins you should, could or just eventually want. Example is list the 09S VDB but no other entry. </p><p>Next suggestion is to add a column for the grade number. Note for example you have a VG for Very Good but you possibly may think it is a -8 or -7. Regardless you could use this column for possilbe later upgrades. Another example is a MS-60 could later be upgraded to a MS-62 so now all you have to do is change the 0 in -60 to 2 in -62. </p><p>You could also use this new column to add RB, R, Br, etc. </p><p>My next suggestion is something you will not like. You should change all the grades to capitals to match everyone elses abbreviations for those grades. ef becomes EF. Then naturally change Condition to Grade.</p><p>Adding columns is free so don&#039;t worry about adding columns. What you could do is save your Excel Spread sheet as it presently is, put on a disc, flash drive, etc. Now you can try all kinds of other things with the one on your computer and if you make a mess of it, so what. You still have the original. </p><p>Another suggestion is why bother with a - for the P coins? If no mint mark just leave the date as 1939, no dash required.</p><p>Slowly this list will get bigger so have your wife show you how to make each line smaller in hight. Of course you then will have to make the letters smaller in height also. OR you could just end up with several pages for each collection. Mine is 3 pages long. </p><p>Now if you really get going with Excel you could add another column for values. You could enter a value for each coin based on numerous sources and note at the bottom that this is an estimate only. Next have your wife show you how to use the ADDITION formulae per column so that as you enter a value Excel will automatically add up everything in that column. It is =SUM(E4:E72) type nominclature. Of course you must enter the column number you are using, not the E in my example. Same with the 4 and 72. Those are the line numebers and they are what you have used. </p><p>I further suggest you save the original without the grades and values. Then you could use this format for addtional sets with different grades and values.[/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in