Hi there, I have a number: -300.565181720644
I need to output from my VBA code as 'scientific' format (##0.0E+0)
I've found that if I format a cell to ##0.0E+0, the vba outputs to the sheet: -300.6E+0 which is correct
but if I try and format the number within VBA (and not save to cell in...