G
grassKutter_dtp
I have a spreadsheet I use to do taxes each year. There are lines
corresponding to each line on the 1040. Income is entered on line 7 and I
sum(d7:d21). This has always worked fine. I set up a worksheet "form" for
my son to use where he only has to enter the appropriate input (wages,
interest, dividends, tax withheld, etc.) and I fill the appropriate cells and
calculate the taxes. I used "LinkedCell" property to place the text field
amount in the appropriate cell, along with amount formatting of the textbox
on LostFocus. Problem: The value goes into the "LinkedCell" fine but is (1)
left-justified and (2) it is ignored by the sum formula. It only will add
using =d7+sum(d8:d21). Modifying the cell format makes no difference except
right-justify which shouldn't be required for "number", "currency" or
"accounting" formats.
corresponding to each line on the 1040. Income is entered on line 7 and I
sum(d7:d21). This has always worked fine. I set up a worksheet "form" for
my son to use where he only has to enter the appropriate input (wages,
interest, dividends, tax withheld, etc.) and I fill the appropriate cells and
calculate the taxes. I used "LinkedCell" property to place the text field
amount in the appropriate cell, along with amount formatting of the textbox
on LostFocus. Problem: The value goes into the "LinkedCell" fine but is (1)
left-justified and (2) it is ignored by the sum formula. It only will add
using =d7+sum(d8:d21). Modifying the cell format makes no difference except
right-justify which shouldn't be required for "number", "currency" or
"accounting" formats.