Thread: Concatenate Text & Numbers Keeping zeros..
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Concatenate Text & Numbers Keeping zeros..
So, have you tried:

=TEXT(E1,"000.0")&" Miles "&B1
or even
=TEXT(A5,"000.0")&" Miles "&A2

Your references are very confusing !!

Hope this helps.

Pete

Reply With QuoteReply With Quote