One way:

Format/Cells/Number/Custom

[=19000000]00000000;[<19000000]0.00;General


In article ,
Ivy wrote:

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)?



--
Ivy