MrExcel Publishing
Your One Stop for Excel Tips & Solutions

data types


Posted by Colin on January 03, 2002 6:29 AM

I don't know if my first one went through so,

I need to know how to change data types from a string to an integer in VB.

Currently I have the current assignment
r = a reference to a cell

the value for this is "02". I need it to be 2

I think it has something to do with the % sign but I don' know the correct syntax

Thanks,
Colin


Posted by Colin on January 03, 2002 6:49 AM

this might be easier

What might be easier is if I giev my full problem and see i it can be solved using a fomula directly in excel.

I have a ton of information.

One of my sheets contains a list of employees and another contains pay scales.

The employees have row and column references to where they are on the pay scale(ie. one column has 2 for which row they are on and the next column has 4 for the column they are in. his is in reference to another sheet)

I need to calculate the amount of pay they will get for the whole year.

The problem is that after a certain date they get a raise. This date is in another column in the employee data table. After this date they rise by two columns on the pay range table.

I don't now if anyone can follow what I am trying to do but it would be a great help if anyone had any insight.

Thanks,
Colin

Posted by Chris D on January 03, 2002 1:09 PM

does "r% = 2" work ?

JWalk says :

Integer: %
Long: &
Single: !
Double: #
Currency: @
String: $

HTH
Chris