Description
NOTE
  • If the string has been formatted, the format needs to be compatible with Excel.
Syntax
Copied!
=VALUE(text)
SAMPLE data
|     | A   | B          | C   | D   | E   |
|:---:|:----|:-----------|:----|:----|:----|
|  1  |     |            |     |     |     |
|-----|-----|------------|-----|-----|-----|
|  2  |     |            |     |     |     |
|-----|-----|------------|-----|-----|-----|
|  3  |     | 4/4/2010   |     |     |     |
|-----|-----|------------|-----|-----|-----|
|  4  |     | 09/08/2012 |     |     |     |
|-----|-----|------------|-----|-----|-----|
|  5  |     | 15/11/2024 |     |     |     |
|-----|-----|------------|-----|-----|-----|
|  6  |     |            |     |     |     |
|-----|-----|------------|-----|-----|-----|
|  7  |     |            |     |     |     |
|-----|-----|------------|-----|-----|-----|
EXAMPLE 1
Copied!
//𝘤𝘰𝘯𝘷𝘦𝘳𝘵 𝘥𝘢𝘵𝘦 𝘪𝘯 𝘵𝘦𝘹𝘵 𝘧𝘰𝘳𝘮𝘢𝘵 𝘥𝘥/𝘮𝘮/𝘺𝘺𝘺𝘺 𝘵𝘰 𝘯𝘶𝘮𝘣𝘦𝘳:: =VALUE(B11:B13)
|     |     A |
|:---:|------:|
|  1  | 40272 |
|-----|-------|
|  2  | 41130 |
|-----|-------|
|  3  | 45611 |

Join our newsletter to stay up to date

Click the button below to sign up for our advanced platform. Get started now and see the benefits for yourself.

EN | VI