Thread: formula help
View Single Post
  #4  
Old February 10th, 2010, 04:26 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
  
Posts: 1,245
Default formula help
John Bundy wrote:
If your number is in column A then in column B type
=2 & A1
and copy it down.



To keep the result as a number instead of text:

=--(2&A1)