Number to text formula setting

%3CLINGO-SUB%20id%3D%22lingo-sub-2267454%22%20slang%3D%22en-US%22%3ENumber%20to%20text%20formula%20setting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267454%22%20slang%3D%22en-US%22%3E%3CP%3EDevice%20%3D%20Windows%2010%20PC%20%3B%20using%20Office%20365%3C%2FP%3E%3CP%3ERecently%20installed%20a%20new%20hard%20drive.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20earlier%20worksheets%20I%20formatted%20certain%20numbers%20to%20a%20specific%20text%20format%2C%20placement%20of%20spaces%20is%20important.%26nbsp%3B%20For%20example%20I%20would%20like%20123456789%20to%20be%20displayed%20as%201%2023%204567%2089.%26nbsp%3B%20The%20formulae%20would%20be%20%3DText(A1%2C%22%23%20%23%23%20%23%23%23%23%20%23%23%22)%3C%2FP%3E%3CP%3EAfter%20upgrading%20my%20computer%20this%20formula%20gives%20me%20123%20456%20789%3C%2FP%3E%3CP%3EIf%20I%20add%20a%20slash%20to%20the%20formula%26nbsp%3B%26nbsp%3B%3DText(A1%2C%22%23%5C%20%23%23%5C%20%23%23%23%23%5C%20%23%23%22)%20it%20returns%26nbsp%3B1%2023%204567%2089.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20do%20this%2C%20as%20this%20mean%20several%20days%20of%20work%20to%20change%20formula.%3C%2FP%3E%3CP%3EI%20would%20just%20like%20my%20formula%20to%20work%20like%20it%20did%20before%20my%20new%20hard%20drive.%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20change%20the%20regional%20settings%20to%20123456789%20instead%20of%20123%20456%20789%20but%20it%20doesn't%20help%20(I%20have%20restarted)%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20excel%20example%20with%20a%20screenshot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2267454%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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)