Format cell to always begin with an "X"

  • Thread starter Thread starter Cheri
  • Start date Start date
C

Cheri

Is it possible to format a cell to always add an "X" at the beginning of the
data input in the cell? I imagine it can be done under
Cell>Format>Number>Custom but am wondering exactly what I would have to put
as the format.

Thanks in advance for your assistance!
 
Is it possible to format a cell to always add an "X" at the beginning of the
data input in the cell? I imagine it can be done under
Cell>Format>Number>Custom but am wondering exactly what I would have to put
as the format.

Thanks in advance for your assistance!
Click to expand...

You just preface each section of the format string with an "X" (with or without
the quotes).

One way would be: xGeneral;x@
--ron
 
Back
Top