Two Formats for One Cell

I

Ivy

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

JE McGimpsey

One way:

Format/Cells/Number/Custom

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

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

Excel does not accept text format! 0
Two columns followed by single page-width column on same page 0
Cell data entering slow! 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Date Formats 4
MS Project Center-Autolink column fields 0
Two columns : Continuous two columns vs Parallel two Column 1
Converting URLs in comments to Markdown-formatted links 2

Top