If you have formulas, pressing F9 should recalculate the sheet and update the number format.
A volatile function will be recalculated whenever calculation occurs in any cells on the worksheet. Non-volatile functions are only recalculated when any of the function's arguments change.
Let's take a look at an easy example to explain this a bit more. Open the Visual Basic Editor and click Insert, Module. Now you can use this function, just like any other Excel function.
Not sure if its just my computer yet, currently testing the issue with different computers.
I use the TODAY() function in an excel worksheet which is accessed using MATLAB (i.e. Now I have to open the excel file just to update the TODAY() function, and this method is a bottleneck in my workflow. EDIT: I'm using MATLAB's built in 'xlsread' command Hi Chris, I understand that you want to get an updated date into MATLAB without having to manually open the Excel Sheet.
The only way the to update the cell is to click on the formula and hit Enter or Tab.