more character after first number

[vasc]

hi my friends,

i use VBa code to concatenate some number.
Problem is to more number in concatenated celll

i try more format , but not work


any idea is briliants..
thanks

[Limor_OP]

Hi
Do you still use excel 2007?

[Fluff13]

Try making this change

Please Login or Register  to view this content.

[Fluff13]

Alternatively you can use

Please Login or Register  to view this content.

which will return the values as displayed.

[vasc]

Thanks @ Fluff13
works

[Fluff13]

You're welcome & thanks for the feedback.

[kvsrinivasamurthy]

New code for UDF

Please Login or Register  to view this content.

[Fluff13]

That code gives the same result as the OP had & does not address the problem.

[kvsrinivasamurthy]

Revised code

Please Login or Register  to view this content.

[Fluff13]

That still shows all the decimal places, which is what the OP was trying to avoid.

[kvsrinivasamurthy]

I did not follow what Op wants.

[Fluff13]

I think the Op wants the concatenated numbers to be the same as the displayed numbers.

[kvsrinivasamurthy]

If so code is

Please Login or Register  to view this content.