Use VALUE when a source file stores real numeric quantities as text strings, and you want a separate calculated numeric column while keeping the original data for audit. Do not automatically convert account numbers, shipment IDs or postal codes with leading zeros: those are identifiers, not quantities, and converting them could permanently discard information.

=VALUE(text)

Zoho’s current official examples include =VALUE("$5") → 5, =VALUE("21:00") → 0.875 (time as a fraction of a day), and =VALUE("1/2/20") → 43832 under that example’s date interpretation. These are documented examples, not a promise that every locale parses a date or currency string the same way. Avoid using ambiguous slash dates in production without configuring and verifying workbook locale.

Version, platform and locale scope

The syntax below is taken from Zoho Sheet’s current public English online function reference checked October 11, 2026. That reference does not identify the first Zoho release supporting this function or prove identical behaviour across historical releases, desktop wrappers, iOS, Android, or account configurations. No such first-supported version is claimed here. The published Zoho examples use semicolons (;) between arguments; syntax displayed by a localized application should be checked in its formula helper rather than copying separators from Excel. Zoho documents spreadsheet locale controls for number, date, currency, and decimal formats. Do not assume text that looks like a number will parse identically under all locales. Zoho locale settings.

Use a new Zoho Sheet spreadsheet. Create these six column headings in row 1, then enter the eight example rows. Select column E as text before entering values, because these are intentionally imported-looking numeric strings; a CSV import may otherwise turn them into numbers. Keep order identifiers in A as text. If importing the included CSV, inspect column types afterward and correct them before comparing formulas. The examples use fictitious records only.

A formula such as =B2 references the first data row, not the header. Enter examples in blank cells, or create a separate Results sheet and select the sample cells to form explicit references. When copying a formula down, check the references advance to the correct rows. Set result cells to General where you want to see the returned value without extra display formatting.

Preparation: Select column E’s format as text before entering the raw prices. Check that E2 visibly contains the text characters 12; if it was imported as a number, the example still illustrates VALUE but not a text-to-number correction.

1. Enter =VALUE("12") in a blank cell; expected numeric 12.
2. Enter =VALUE(E2) in G2; with E2 holding text 12, expected numeric 12.
3. Enter =VALUE("7"); expected numeric 7.
4. Enter =VALUE(E3) in G3; with E3 holding text 7, expected numeric 7.
5. Enter =VALUE(E4); E4 contains text 0, expected numeric 0.
6. Zoho’s published example =VALUE("$5") has expected numeric 5; confirm the active workbook’s currency locale if using it on real data.
7. Zoho’s published time example =VALUE("21:00") has expected 0.875, because 21 hours equals 21/24 of a day. A cell formatted as time may display a clock time instead of that numeric fraction.

Suppose the raw price in E2 was imported as text 12, and D2 is numeric quantity 3. Calculate:

=VALUE(E2)*D2

Expected result: 36 (12 multiplied by 3). For row 3, =VALUE(E3)*D3 should give 14. Keep the source price in E and store the calculation elsewhere so you can compare incorrect imports or rounding later. Before summing totals, scan for invalid entries, and do not hide conversion failures with a blanket IFERROR fallback without recording what failed.

For real cash amounts, first check decimal/thousands separator conventions and currency symbol; then validate imported results against a trusted total. Currency formatting on the result cell affects appearance, not the underlying numeric output.

Parsing caution: The Zoho help page demonstrates several formats but does not guarantee the treatment of commas, international currency symbols, all dates or arbitrary unit suffixes. Do not claim VALUE can normalize every international number format. Formatting, validation and conversion are separate tasks.

Both Zoho and Excel document VALUE to interpret text representing numbers. Excel uses VALUE(text) as well, but Zoho’s help examples include currency, date and time conversions whose outcomes can depend on spreadsheet locale or date conventions. A workbook that works under one date setting may convert differently in another. Compare outputs in the target application rather than treating a formula-name match as semantic equivalence. Use the original text source to detect problems before importing business-critical amounts.

Quick questions

Why does VALUE("21:00") produce a decimal? Time can be stored as a day fraction; Zoho’s example uses 0.875 for 21 hours.

Should VALUE convert tracking numbers or IDs? No; preserving leading zeros and formatting is normally more important than arithmetic on identifiers.

Will VALUE fix every currency string? Not reliably without locale checks and input cleaning; verify real imports and flag failed records.

• CONCATENATE — join several text values.
• REPT — repeat text without building a string manually.
• CHAR — get a character from its numeric code.
• CODE — inspect the first character’s code.
• VALUE — convert text representing a number into a numeric result.
• LEFT, LEN, TEXTJOIN, and TRIM — related text tools under review.

• Zoho Sheet — function documentation
• Zoho locale settings

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.