Conditional format number

  • Thread starter Thread starter goss
  • Start date Start date
G

goss

Hi ng
Use mix of xl 2002 and 2003

I would like to format my numbers so if value in colF is blank or
then format my formula result in colK for accounting format, no symbol
2 decimal places.

Otherwise format with date format mm/dd/yyyy

Sample data Cell F5:
10/1/2004 8:35:39 AM

Sample formula Cell K5:
=IF(ISERROR(VALUE(LEFT(F5,10))),0,(VALUE(LEFT(F5,10))))

And I currently have custom format on ColK for mm/dd/yyyy

However, soemtimes this leaves me with:
01/00/1900

Which I do not wan
 
Altough I don't like this very much, this should do it:

=IF(ISERROR(VALUE(LEFT(F5,10))),"0",(VALUE(LEFT(F5,10))))
 
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

Excel 2002: How to make the date format uniform ? 1
Formatting Dates from Text to Numbers 2
Date Format 2
counting records by month and year / date format issues 1
Formatting Text to Numbers for Dates 2
Excel 2007 displayed dates 2
Sumproduct and Date format 1
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8

Back
Top