Convert imported text into numbers
Your goal: Convert amounts with an explicit decimal convention, keep missing values blank, and flag text that cannot be parsed.
Full task requirements
Convert A2:A7 into B2:B7 using a dot decimal and comma group separator. Keep empty inputs blank and return Check value for invalid text.
Imported amountsInterpret the imported value in A2
Read the original text spelling before choosing a numeric result. Empty text and numeric zero are separate results.
| # | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 |
Step 1 of 6
Interpret the imported value in A2
Rules for this step
Choose the source value, decimal and group conventions, then predict its stored result type. Empty input stays empty text; zero is a number; invalid text returns Check value.