6-16-2021


Dear Purfleet:


1. Jeez!


2. Thank you very much.


3. This is way over my head; I'm not sure which disturbs me more-- the complexity of the formula or the speed of your response with it.


4. Would you please be much more specific in offering the instruction: "then in the next column add zero to make it a number"--when you say "in the next column" are you speaking about a column that this formula will create which does not exist before the formula acts upon the given Date column? This is a little confusing-- you first ask me to create a blank column (I assume to the right of the existing Date column) and then speak of "in the next column" which as the spreadsheet stands now contains information describing the payee for the transactions-- I'm sure you don't mean add a zero to any of those cells. You must mean add a zero to data that will appear in the initially blank column just created to the right of the Date column, don't you? And where exactly will that zero be "added" in each cell? "Added" how? To the very end of whatever digits are displayed in that column?


You see the difficulty I have visualizing this.


5. Are you absolutely sure there is no simpler way to convert the text information in the Date column to numerical information on which Date formatting can act?


Many thanks. I'm most impressed.


geobar