The code above gives the result -4.9999999999883
But the code below gives the result -499999.99999883
The
pattern ##0.## do not have any 'E' but still it is able find out the exponential representation when an 'E' is used , but it can not find the exponential representation when a 'e' is used.
but the code below works fine with both 'E' & 'e'
Do you have an explanation ?.