| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text to Integer
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 -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=551912 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text to Integer
=VALUE(your text string)
or (your text string)*1 -- Allllen "jerredjohnson" wrote: 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 -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=551912 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text to Integer
Hi
One way is to copy a blank unused cell, select your range and then Edit/Paste Special/Add. Andy. "jerredjohnson" wrote in message news:jerredjohnson.29efpd_1150300202.3598@excelfor um-nospam.com... 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 -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=551912 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text to Integer
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. -- Gary's Student "jerredjohnson" wrote: 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 -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=551912 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Text to Integer
THe =value(text) worked perfectly THANKS! -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=551912 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having macro convert text to numbers | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
| Count and convert text | Excel Worksheet Functions | |||
| How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
Linear Mode
