Jun 17 2019 07:56 AM
Using Excel build 1905 (office professional plus 2016).
For some reason as of latest update, any value with more than 2 decimal places changes format (from General) and has incorrect value in cell. i.e. 1.111 changes to 1111. This is in a new blank spreadsheet.
Any ideas?
Thanks
Jun 17 2019 09:08 AM
Jun 17 2019 03:00 PM
Jun 18 2019 01:41 AM
Jun 18 2019 01:57 AM
Yes, it returns 11.11 when typing 1111, but I'm not sure there is no misprint in the question.
Jun 18 2019 05:35 AM
Thanks Jan, This was the problem.
I noticed the changes directly after doing the routine office upgrade. I use excel every day so seemed to definitely relate to this. Other observation was that the currency formatting had changed but probably the same issue.
Thanks again for your help
Jun 18 2019 05:40 AM
Basically on third digit after a decimal, the format always changed so 1.111 went to 1111 and 11111 went to 11.111
Thanks