I'm trying to write a macro that takes a time value in seconds (decimal) and converts it to mm:ss.00 format (two decimal places.) The closest I've come is this:
Application.Text((1.23 / 86400), "mm:ss.00")
Which results in:
I can't figure out why it's not showing the second decimal place. Format() doesn't work either, it does something even weirder.