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"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert a range of numbers to strings 2
myCell.Formula application unknown object error 4
Excel Convert text to Number 9
Produce Random Numbers 6
Reduce Numbers Down To A Specific Value 1
Need help converting number string to number 3
Convert text to values 6
Convert Date-as-Text 3

Back
Top