Apr 12 2021 01:25 AM
Device = Windows 10 PC ; using Office 365
Recently installed a new hard drive.
In my earlier worksheets I formatted certain numbers to a specific text format, placement of spaces is important. For example I would like 123456789 to be displayed as 1 23 4567 89. The formulae would be =Text(A1,"# ## #### ##")
After upgrading my computer this formula gives me 123 456 789
If I add a slash to the formula =Text(A1,"#\ ##\ ####\ ##") it returns 1 23 4567 89.
I don't want to do this, as this mean several days of work to change formula.
I would just like my formula to work like it did before my new hard drive.
I have tried to change the regional settings to 123456789 instead of 123 456 789 but it doesn't help (I have restarted)
I have attached an excel example with a screenshot
Apr 12 2021 11:35 AM
Don't know why, but for me it returns desired result
Same will be with your formula if recalculate (Ctrl+Alt+Shif+F9)