I set up a spreadsheet to print my checks on. Everything looks good, even making the duplicate copy on the bottom part of the check so I have a copy automatically for my records.
My one issue is that in the cell where I write out the dollar amount:
"Two Hundred Seventy-six & 14/100*************************************"
I always want the asterisks to end at the same point - so that that cell is completely filled to the end with asterisks and yet does not run into the word "Dollars" which is preprinted on the check.
If I REMEMBER (which is expecting a little too much) when I get to that cell I can hit the "Insert" key and type in the new amount. If that amount is shorter than previously there, I can just asterisk without paying much attention until I get to where there are already some there.
WHAT I WOULD LIKE TO DO is to have that one cell be automatically formatted such that I can leave the Insert key out of the picture and the amount will be "overwritten" rather than blanked out.
thanx to all for your help or consideration.
Geezer:-D
Go to format cells, under Category, select custom, then set up a custom format with "@**" minus the "" marks. The @ symbol is a place holder for your text, the first * tells Excel to fill the remainder of the cell with the next character, and the last * tells Excel to use asterisks to fill the remainder of the cell.
Edit: added screenshots
You can see in the Fx box the actual text I keyed into the cell and in the bottom of the first image you can see how I set up the custom format. The second image shows the result.
Stephen,
WOW!!!!! Am I blown away.
it worked perfectly and much much easier than I ever thought.
Many Thanx,
Geezer:-)
Thanks,
learned something new today!
Chr.
