| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I convert text cells to value
I have download a lot of information from my online bank statement to do my
year end accounts - like I have down for the last 7 years except for some bizare reason the values are all showing as text and I need to conert them text to value. Help ther eare hundreds of line items |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert text cells to value
Is there a colored triangle in the upper left corner? If so, then when you
pass over it you should get a diamond shaped icon w/ an exclamation point inside. If this is so, then highlight all the problem cells, click down on the icon and choose convert to number... "nreynol" wrote: I have download a lot of information from my online bank statement to do my year end accounts - like I have down for the last 7 years except for some bizare reason the values are all showing as text and I need to conert them text to value. Help ther eare hundreds of line items |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert text cells to value
"nreynol" wrote: I have download a lot of information from my online bank statement to do my year end accounts - like I have down for the last 7 years except for some bizare reason the values are all showing as text and I need to conert them text to value. Help ther eare hundreds of line items |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert text cells to value
You can use the VALUE function to convert the text to numbers. Just use the
formula =VALUE( cell with the text number ). For instance =VALUE(B2) "nreynol" wrote: I have download a lot of information from my online bank statement to do my year end accounts - like I have down for the last 7 years except for some bizare reason the values are all showing as text and I need to conert them text to value. Help ther eare hundreds of line items |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert text cells to value
post samples of the numeric (text) data you currently are dealing with..
"nreynol" wrote: I have download a lot of information from my online bank statement to do my year end accounts - like I have down for the last 7 years except for some bizare reason the values are all showing as text and I need to conert them text to value. Help ther eare hundreds of line items |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
| How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
Linear Mode
