| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Text to Numbers
I am currently exporting data from Excell from a system that i use. When i
look at the data the numbers are stored as text. Despite everything i cannot the data to a number format. Any ideas? P.s i've tried copy and special pasting formats etc. Also data stored as a number cannot be changed into text. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Text to Numbers
First make sure the text has no extra blanks or special characters.
Then enter 1 in an un-used cell, copy this cell and paste/special multiply over the cells you want to convert. -- Gary's Student "Hawksby" wrote: I am currently exporting data from Excell from a system that i use. When i look at the data the numbers are stored as text. Despite everything i cannot the data to a number format. Any ideas? P.s i've tried copy and special pasting formats etc. Also data stored as a number cannot be changed into text. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Text to Numbers
Thanks Gary,
If there is a date format, which is set-up as UK format but my computer is set-up as US region (due to the systems i use) is there a way of converting this? Date format is 12-21-2006 etc "Gary''s Student" wrote: First make sure the text has no extra blanks or special characters. Then enter 1 in an un-used cell, copy this cell and paste/special multiply over the cells you want to convert. -- Gary's Student "Hawksby" wrote: I am currently exporting data from Excell from a system that i use. When i look at the data the numbers are stored as text. Despite everything i cannot the data to a number format. Any ideas? P.s i've tried copy and special pasting formats etc. Also data stored as a number cannot be changed into text. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Text to Numbers
Consider using the DATEVALUE() function in a helper cell.
See Excel Help -- Gary's Student "Hawksby" wrote: Thanks Gary, If there is a date format, which is set-up as UK format but my computer is set-up as US region (due to the systems i use) is there a way of converting this? Date format is 12-21-2006 etc "Gary''s Student" wrote: First make sure the text has no extra blanks or special characters. Then enter 1 in an un-used cell, copy this cell and paste/special multiply over the cells you want to convert. -- Gary's Student "Hawksby" wrote: I am currently exporting data from Excell from a system that i use. When i look at the data the numbers are stored as text. Despite everything i cannot the data to a number format. Any ideas? P.s i've tried copy and special pasting formats etc. Also data stored as a number cannot be changed into text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
| Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
| Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Linear Mode
