Add text strings together as value

[VegasNath]

How can I convert text numbers into a cell as a value?

=VALUE(A61)&VALUE(B61)

Example:

A61 = 348286
B61 = 5

vba formula in A62 something like "=VALUE(A61)&VALUE(B61)" to return 3,482,865

Sorry, this seems so simple but I'm stuck in a dull moment.

[HansV]

I think you want

Range("A62").Formula = "=VALUE(A61&B61)"

(You want to concatenate first, then convert back to a number.)

[VegasNath]

Yes, that works except it returns 3,482,865.00

How can I lose the .00

[HansV]

By setting the number format for the cell, either interactively or through code:

Range("A62").NumberFormat = "#,##0"

[VegasNath]

Cheers Hans