• Miscellaneous Functions
  • ASSIGNEDTO Function
  • B64TOGUID Function
  • BROWSTAT Function
  • CANSIGN Function
  • CELLCALC Function
  • CELLCOL Function
  • CELLLABEL Function
  • CELLNO Function
  • CELLROW Function
  • CELLSTR Function
  • CELLTABLE Function
  • COMPLETION Function
  • COMPLTBY Function
  • CUSTPROP Function
  • CUSTPROPAT Function
  • CUSTPROPR Function
  • CVDATA Function
  • CVDATAC Function
  • CVDATAL Function
  • CVDATALNG Function
  • CVDATAQRY Function
  • CVDOCPOS Function
  • CVFORM Function
  • CVGROUP Function
  • CVIDEA Function
  • CVINFO Function
  • CVMENUST Function
  • DOCENTSCP Function
  • DOCID Function
  • DOCLIBPATH Function
  • DOCMODE Function
  • EVAL Function
  • FIELD Function
  • GETHIDE Function
  • GUIDTOB64 Function
  • HASTAG Function
  • INITIALS Function
  • INPBLANK Function
  • INPBLANKRC Function
  • ISADMIN Function
  • ISCONS Function
  • ISINGROUP Function
  • ISLOCKED Function
  • ISPLHOLDER Function
  • ISSUECOUNT Function
  • ITEMPROP Function
  • KLIEXIST Function
  • KLIPROP Function
  • KLLPROP Function
  • LEVEL Function
  • LOOKUP Function
  • Miscellaneous Functions
  • MKPATH Function
  • NUMROLES Function
  • NUMSIGNED Function
  • RDYREVIEW Function
  • REPENT Function
  • ROLECOMPLT Function
  • ROLEINDEX Function
  • ROLELABEL Function
  • SCRNX Function
  • SCRNY Function
  • SIGNOFF Function
  • SIGNOFFCHK Function
  • SIGNOFFCVR Function
  • SIGNOFFDTE Function
  • SIGNOFFNME Function
  • WHOAMI Function

CELLSTR Function

The CELLSTR function returns the formatted contents of a cell number as a string into the current cell.

Syntax

CELLSTR(<cell number>)

A cell number must be specified and it returns the formatted contents number of that cell, as a string. This reference must be a direct cell reference.

Example 1

Enter CELLSTR(c1) where c1 is a number cell, with a value of 1000 formatted to display as $(1,000)

Returns the string $(1,000). If not using CELLSTR function, the value returned would have been 1000 – the absolute value of the cell.

CELLSTR works with any specially formatted cells, such as date cells.

Related Topics

• Miscellaneous Functions