| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers in text format
i have downloaded a report that contains a column full of numbers that are
not recognized as numbers but rather text and can therefore not be used in the SUM formula. the column contains over 13000 rows. is there anyway to turn these numbers into numbers - aside from hitting F2 and enter on each and every cell? thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbers in text format
A solution I remember reading on here a while back.
in a seperate cell put a 1 Copy that cell then Select the column of 'text-numbers' Paste Special... Choose Multiply Should work Steve On Thu, 05 Oct 2006 15:35:02 +0100, hotelmasters wrote: i have downloaded a report that contains a column full of numbers that are not recognized as numbers but rather text and can therefore not be used in the SUM formula. the column contains over 13000 rows. is there anyway to turn these numbers into numbers - aside from hitting F2 and enter on each and every cell? thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbers in text format
thanks steve - you are the MAN!
"SteveW" wrote: A solution I remember reading on here a while back. in a seperate cell put a 1 Copy that cell then Select the column of 'text-numbers' Paste Special... Choose Multiply Should work Steve On Thu, 05 Oct 2006 15:35:02 +0100, hotelmasters wrote: i have downloaded a report that contains a column full of numbers that are not recognized as numbers but rather text and can therefore not be used in the SUM formula. the column contains over 13000 rows. is there anyway to turn these numbers into numbers - aside from hitting F2 and enter on each and every cell? thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbers in text format
you can also use this formula and leave them as text
=SUMPRODUCT(--(A1:A13000)) "hotelmasters" wrote: i have downloaded a report that contains a column full of numbers that are not recognized as numbers but rather text and can therefore not be used in the SUM formula. the column contains over 13000 rows. is there anyway to turn these numbers into numbers - aside from hitting F2 and enter on each and every cell? thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
numbers in text format
Click on the column (to highlight the entire column), go to Data Text to
Column, select Finish. "Sloth" wrote: you can also use this formula and leave them as text =SUMPRODUCT(--(A1:A13000)) "hotelmasters" wrote: i have downloaded a report that contains a column full of numbers that are not recognized as numbers but rather text and can therefore not be used in the SUM formula. the column contains over 13000 rows. is there anyway to turn these numbers into numbers - aside from hitting F2 and enter on each and every cell? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format text to numbers | Excel Discussion (Misc queries) | |||
| Parse text & numbers & format | Excel Worksheet Functions | |||
| Parse text & numbers & format | Excel Worksheet Functions | |||
| Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
