Convert Text to Integer

[jerredjohnson]

I am not familiar with all of excels functions but im sure someone out
there knows this off the top of their head. What function allows me to
convert text strings to integers?

Thanks!
Jerred

 

[Allllen]

=VALUE(your text string)
or
(your text string)*1

 

[Guest]

Hi
One way is to copy a blank unused cell, select your range and then
Edit/Paste Special/Add.

Andy.

"jerredjohnson" <[email protected]>
wrote in message
news:[email protected]...

 

[Gary''s Student]

If you have a number in text format or a number preceeded by an apostrophe,
then in an un-used cell enter 1. Copy that cell. Select the cells that you
want to convert.
Paste/Special with the multiply button checked.

 

[jerredjohnson]

THe =value(text) worked perfectly
THANKS!