I have a table with dates in one column and the description in another. I created a formula for the description to include the date [ex: ="Description "&"("&A4&")" where A4 is the cell with the date; it would appear in the cell as Description (8/25/3000)]. Many of the descriptions are the same but with different dates. This formula works for the most part except for one particular document type (pay stubs) that I copy.
The pay stubs cell is usually three lines when I copy the formula. But when it pastes, it's only two lines. I unwrap and rewrap the cell which usually fixes the problem but it doesn't work. The strange thing is, when I copy an earlier pay stub cell it works (ex: copy cell B20 to B130). But if I copy the new cell (ex: B130) and paste into a different cell (ex: B185) it won't autofit. I have all the rows set to autofit but it doesn't work for this pay stubs. I think there may be some incompatibility issues because the earlier working cell (B20) was done on my computer at home and I'm working on my laptop.
I would share the excel document itself but it has sensitive information and I can't share it. I tried to replicate the problem in a new blank excel document but the problem wasn't transferring into the new document. I even copied the cells that weren't working (B130) but when I unwrapped and rewrapped the cell, the autofit worked. I have no idea where this problem came from but it's really frustrating.
Edit: solved the problem. The date was not set to Date format. That seems to have fixed the problem
Bookmarks