Reformatting a number

[Brian]

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]

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

 

[Brian]

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]

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]

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

Thanks,
Brian

 

[Anne Troy]

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