I'm using =int(A2) to drop the time stamp from an imported report. When I copy the formula down, the cell reference changes as expected but the output still equals the same as the cell I copied the formula from. However, if I click in the cell that's giving me the wrong answer (or on the forumula bar), the result changes to the correct answer.
I don't see any formula error indicators. Thanks.
Bookmarks