Thanks Alan,
Thank you for the effort. I wil copy and paste the format you given.

"Alan" wrote:

"Bluesy69" wrote in message
...

I need help in excel,formatting of numbers. Example
1548,6981,1032,6710 to display in excel in order preferences as
1458,1689,0123,0167. Thank you.


Hi,

I almost got to a totally generic solution for you, but I ran out of
time.

This assumes that each number is four digits long, but only the last
part {1000;100;10;1} makes that assumption and I imagine that would be
easy to fix to generalise totally.

Anyway, try this:

{=MMULT(TRANSPOSE(SMALL(VALUE(MID(TEXT(A1,"@"),ROW (INDIRECT("1:"&LEN(T
EXT(A1,"@")))),1)),ROW(INDIRECT("1:"&LEN(TEXT(A1," @")))))),{1000;100;1
0;1})}

Enter as an array formula.

HTH,

Alan.