Administration and Executive AssistantTier 820 minintermediate

NUMBERVALUE and Number Formats

Parse a figure written in European number format, with the decimal and thousands separators reversed.

What you will learn

• Use NUMBERVALUE with explicit decimal and group separator arguments
• Explain why a figure in European format breaks NUMBERVALUE's (and VALUE's) default assumption
• Recognise that the wrong convention does not silently misparse the number - it returns #VALUE!

Excel skills

NUMBERVALUE · Text Extraction

The task

Eight figures came in from a European system, written with a comma as the decimal point and a period separating thousands. Parse each one into a real number in column B.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free