Forum Discussion
Solved
Formula Output to Wrong Cell
Hello, I created a spreadsheet in Excel that automatically time and date stamps C2 when data is input into B2. I have to use the spreadsheet in a Microsoft Teams account. When I imported the spreadsheet to Teams something happened to where the time and date output. In the Teams version of my spreadsheet when I input data in B2 it outputs into C3 (both highlighted in red in the screenshot). The formula clearly shows that it should output into C2. I would appreciate any help in fixing this issue.
- If you make a change in column B and hit control+Enter instead of "just" Enter, does it work as expected?
- If you make a change in column B and hit control+Enter instead of "just" Enter, does it work as expected?
JKPieterse Yes. That worked. Any idea how I train all of my personnel to do that? Thanks for the reply!
