Wednesday 31 July 2019

Imported CSV file into Excel but cannot convert the numerals from TEXT to a usable number format in order to calculate sums

I've imported a CSv file into excel - but the numbers are in a TEXT which I cannot use in calculations


How can I convert the numerals into a usable format to complete calculations ?

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...