change data from text to numeric

B

brichler

after using Instr() to select a number from a text string, I would like
to use Group By and Sum on this data. However, I am getting the old
"data mismatch in criteria expression" error, I think because my source
data is text, and the end result needs to be numeric.

what would you suggest?

thank you-
sarah
 
T

Tom Lake

after using Instr() to select a number from a text string, I would like
to use Group By and Sum on this data. However, I am getting the old
"data mismatch in criteria expression" error, I think because my source
data is text, and the end result needs to be numeric.

what would you suggest?
Click to expand...

Use the Val function to convert the result of the Instr to numeric.

Tom Lake
 
Top