deepcalc
DocsVALUE

VALUE

View as markdown/docs/functions/value.md Ask Claude about this pageOpens Claude with this page's address

Converts text string to a number.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=VALUE("1234")
Result 1234

Syntax

VALUE(text)
text
text required

Errors

#VALUE!
=VALUE("alpha")
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.