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
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