CONCATENATE & VLOOKUP
 

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.

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.

CONCATENATE & VLOOKUP
 

THANK YOU. In addition to this, how would I apply the same principal to
dates. Ie if I have a date on a worksheet styled 01/07/08, how can I
CONCATENATE/VLOOKUP to change this to 1 July 2008 ?????

...thanks

"Bernie Deitrick" wrote:

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.

CONCATENATE & VLOOKUP
 

=CONCATENATE(TEXT(VLOOKUP(.....),"d mmmm yyyy"),.....)

Bernie

"David Brereton" wrote in message
...
THANK YOU. In addition to this, how would I apply the same principal to
dates. Ie if I have a date on a worksheet styled 01/07/08, how can I
CONCATENATE/VLOOKUP to change this to 1 July 2008 ?????

..thanks

"Bernie Deitrick" wrote:

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.

CONCATENATE & VLOOKUP
 

Thank you very much.

"Bernie Deitrick" wrote:

=CONCATENATE(TEXT(VLOOKUP(.....),"d mmmm yyyy"),.....)

Bernie

"David Brereton" wrote in message
...
THANK YOU. In addition to this, how would I apply the same principal to
dates. Ie if I have a date on a worksheet styled 01/07/08, how can I
CONCATENATE/VLOOKUP to change this to 1 July 2008 ?????

..thanks

"Bernie Deitrick" wrote:

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.