CONCATENATE & VLOOKUP
Change the value from the VLOOKUP into text:
=CONCATENATE(TEXT(VLOOKUP(.....),"0.00"),.....)
--
HTH,
Bernie
MS Excel MVP
"David Brereton" wrote in message
...
Help.... when using the above formula, how can I transfer figures from
another spreadsheet without losing the decimal places . ie a figure of 125.40
transfers as 125.4 and 123.00 transfers as 123.
Thanking you in advance.
|