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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formats 4
I am trying to use the IF and SUMIF function on Excel 8
Date is not permanent 2
Formula 0
How do I format a cell in Excel to show a dash instead of 0.00? 2
formula for decimal point 4
eliminating decimal places 4
Date and Number cell formats 4

Back
Top