Converting strings to numbers

  • Thread starter Thread starter Big Bitty
  • Start date Start date
B

Big Bitty

I want to join the values of a range of cells (say 1, 2, 5, and 8) to produce
the number 1258, which can then be used in other calculations. Any ideas on
how to do this?

I'm using Excel from Office 2000

Many thanks
 
Formula
=--(C9&D9&E9&F9)

VBA code
varData = --(Range("C9") & Range("D9") & Range("E9") & Range("F9"))
 
Back
Top