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.
Last edited by tolson; 06-02-2011 at 03:55 PM.
It sounds like calculation is set to manual or the cell is formatted as text. Probably calculation set to manual.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks