INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Text to Numbers

Text to Numbers

(OP)

I have some code to put text into cells like this:

Range("A" & intEcRow & ":" & strL & intEcRow).Value = strLine

where strLine as an array of values declared as String.

One of the columns get the values of:

Total

1.11
1.1
1.0
1.01
See Proposal
See Proposal
1.10
0

and the column is formatted as Text because user wants to see 1.0 or 2.00

Now the user wnats to have the same information on another sheet and wants to see the numbers as numbers.

How can I convert:
'1.11
'1.1
'1.0
'1.01
'See Proposal
'See Proposal
'1.10
'0

(Single quotes are there becasue it is text)
to numbers:

Total
1.11
1.1
1
1.01
See Proposal
See Proposal
1.10
0


I just want to adjust the column with the text to be numbers, I don't want to Copy/Paste special

Have fun.

---- Andy

RE: Text to Numbers



A

Don't know why you posted here.

Just "transfer" the data to another sheet. Here I have Sheet2 as the other.

CODE

Private Sub Worksheet_Change(ByVal Target As Range)
Dim t As Range

For Each t In Target
If Not Intersect(t, Columns(1)) Is Nothing Then
Sheet2.Cells(t.Row, "A").Value = t.Value
End If
Next
End Sub

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Text to Numbers

(OP)

Sorry Skip, wrong forum - no wonder I could not find this post...

It was answere by you here.

Have fun.

---- Andy

RE: Text to Numbers

Actually I answered the question differently, because here you stated, "I don't want to Copy/Paste special."

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close