Reformatting a number

Brian · Oct 17, 2005

Howdy All,

I need to format some numbers for printing.

The number are 10 digit in column A.

Example: 2468513457

I need it to look like this:

2468 51 34 57

Thanks,
Brian

Anne Troy · Oct 17, 2005

Format-->Cells, Number tab. Choose Custom Format, and type: 0000 00 00 00
************
Anne Troy
www.OfficeArticles.com

Brian · Oct 17, 2005

Thanks Anne.

Just realized that the numbers are stored as text in order to get leading
zeroes.

Any ideas on how to format the text?

Roger Govier · Oct 17, 2005

Hi Brian

Anne's solution will hold the leading zero, so it shouldn't be a problem.

Alternatively you could use a formula in another column
=TEXT(A1,"0000 00 00 00")
Copy down the range.
Copy the whole of this new column, move cursor to A1 and Paste Special>Values

Regards

Roger Govier

Brian · Oct 17, 2005

Thanks Roger, I couldn't get Anne's to work, but your's did.

Thanks,
Brian

Anne Troy · Oct 17, 2005

Hi, Brian. I suspect your numbers were already formatted as text, and that's
why it didn't work. Mine would only work with numbers, not text.
************
Anne Troy
www.OfficeArticles.com