If you would rather keep it as a number and just format for display
purposes, use the custom format 000000 00000

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
Hi,

I have a column with formatted leading zero integer values like this:

12345678910
00123456789

and I need to insert a space in this string like this:

123456 78910
001234 56789

I tried to use this function,

=MID(F1;1;6)&" "&MID(F1;7;5)

however it interprets cells as integer values and not the cells' formatted
text values.

How can I in my formula use the cells' actual displayed formatted text
instead of the integer value?

Thanks a lot for hints on this

regards

Rod