PDA

View Full Version : Excel Formula full update?



nikki333
07-03-2018, 12:52 PM
Hi Folks

I'm currently going mad on an issue with updating formulas...

For example (pic below) i've formated this 2nd column with a short date format like 26.6.17 instead of 26.06.2017.

However, nothing happens until i activate the formula bar and hit enter very aggressively :) then it works (for the current cell). but now, the list is long, this can't be the right way to do it

I don't understand why recalculating doesn't do the trick,...and the date problem is just an example

22515

macropod
07-03-2018, 04:01 PM
This is a duplicate of: http://www.vbaexpress.com/forum/showthread.php?63099-Excel-Formula-full-update
Kindly don't do that. Thread closed. You may continue the discussion in your original thread.