Replacing the problem characters

Please sign up for the course before starting the lesson.

If the VALUE function doesn't work, then there must be some characters that are confusing Excel into believing that a 'number' is actually text. Firstly we need to see what these are. Sometimes you can see them straight away but sometimes you need to play within the cells to see what you need to do to make Excel see a number. Take a few cells and delete the characters that you think are causing the problem (typically commas, full stops, spaces). After each enter you should be able to see whether Excel has converted the cell into a number or is looking closer to a number. Once you know what the problem is you can address it...

Back to: Data cleanup in Excel > Convert 'Text' fields into usable numbers