View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Brereton[_2_] David Brereton[_2_] is offline
external usenet poster
 
Posts: 10
Default 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.