Using non-numerical imported data

[Ricardinho]

When importing data from financial websites, some of it
comes in as 171.1Mil instead of 171.1 , which means Excel
won't recognise it as a figure and I can't manipulate it.
Any suggestions? thanks

 

[Andy B]

Hi

You could use Data/Text to columns to split off the text bit, or use
=--LEFT(E14,LEN(E14)-3) to trim it off.

Andy.