| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup & Concatenate? | Excel Discussion (Misc queries) | |||
| Vlookup, Concatenate, Format | Excel Discussion (Misc queries) | |||
| Concatenate and Vlookup | Excel Worksheet Functions | |||
| Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
| Can you use Concatenate with the If function with vlookup in the i | Excel Worksheet Functions | |||
![David Brereton[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
