Wrong concatenate results

G

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
 
F

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
 
Top