Wrong concatenate results

[goss]

Hi ng.
Using xl2003

ColA is unit 79990001
ColE is account 7001.3038
ColG concatenates =VALUE(CONCATENATE(A2,E2))
I formated 000000000000.0000

I would expect 799900017001.3038
Instead I receive 799900017001.3030

Why is this and how do I correct

 

[Frank Kabel]

Hi
problem is Excel only supports 15 significant digits. and you have 17
in your concatenated result. So this is simply not possible if you need
the value as numeric value