Two Formats for One Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have two formats in one cell. I have a column in which
dates or decimal points will need to be keyed (ex. 20070301 or 0.00)?
 
One way:

Format/Cells/Number/Custom

[>=19000000]00000000;[<19000000]0.00;General
 
Back
Top