how do I convert text cells to value

  • Thread starter Thread starter nreynol
  • Start date Start date
N

nreynol

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
 
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 said:
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
Click to expand...
 
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)
 
post samples of the numeric (text) data you currently are dealing with..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What software do you use to convert between audio files? 6
How to synchronize all cell values? 1
Convert Numbers to Text 4
Convert Text to Date Month and Year 1
converting text cell to numeric cell 5
Convert numbers stored as text to numbers 2
how do I test for a text value in cell c1, if it is there, make c. 1
from date format convert to text format is wrong 2

Back
Top