<div>
It is much better to leave the value alone, to allow for using it further for calculations etc.<br />
Perform formatting via the display format only: ## ### ### ###
</div>


It is much better to leave the value alone, to allow for using it further for calculations etc.
Perform formatting via the display format only: ## ### ### ###

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have an Excel Spreadsheet with a column containing data like 12123456789.<br />
Does anyone know the formula to change this to 12 123 456 789<br />
<br />
Thanks.
</div>
</div>


Hello,

I have an Excel Spreadsheet with a column containing data like 12123456789.
Does anyone know the formula to change this to 12 123 456 789

Thanks.

Inserting a Space using a Formula in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.