Number to text formula setting

Occasional Visitor

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

1 Reply

@Meryn1305 

Don't know why, but for me it returns desired result

image.png

Same will be with your formula if recalculate (Ctrl+Alt+Shif+F9)