How can I insert a space between each number?

Hi there

I'm working at a printing office and we have a questionaire that we are going to number from 10000-10999. The problem is that I need to insert a space between each number digit (ex. 1 0 9 9 9 - # # # # # instead of #####) to make it hit the boxes prepared for the numbers. I have a column with the text "Numbers" at the top and then all the numbers underneath.

But I can't get any solution to work correctly. Can anyone help me?

I'm not experienced in Excel in any way...

In advance thanks for your help.

If your number is in cell A1, say, you could try :

=TEXT(A1,"# # # # #")

Hi Andrew, I trid to write this into cell B2 (my numbers are in cell A2 and further down), but I only got an error message. Is there a special place to write this?

What exactly is in cell A2? Is it just a number or is it literally, "10999-10000"?

Let's see if I can get this right. I'm trying to upload the file to depositfiles.com.

http://depositfiles.com/files/271d9gxxu

The numbers are in cells A2-A1001.

You don't need to use DepositFiles, you can upload files directly to the forum (click on the paper-clip icon when you're writing a message in advanced mode).

However using my formula (but pointing at A2 instead of A1):

=TEXT(A2,"# # # # #")

Works for me if I put it in cell B2. What error were you getting?

OK, I've put my formula in column B and another formula, showing you how to use the same function on the returned value from a calculation, in column C.

These are both working for me - are they OK for you?

Originally Posted by Andrew-R

OK, I've put my formula in column B and another formula, showing you how to use the same function on the returned value from a calculation, in column C.

These are both working for me - are they OK for you?

It worked :D Hurray!

Thanks a lot Andrew-R and have a great day. You saved us a lot of trouble.

Just one question, I don't know a lot about excel, but did you make the numbers into text? Just wondering because it said "TEKST" (Norwegian for text) in the beginning of your formula.

TEXT is a slightly mis-leading term - it's actually the function to convert a numeric value into a specific display format (the result will be text, however).

Glad you're sorted.