How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
53785
Type Your Question Here...
John D is online now
A new question is answered every 9 seconds

I have an Excel sheet that I have globally made into date format.

This answer was rated:

I have an Excel sheet that I have globally made into date format. I want one row as date, one row number (0 digits after the .). I can find the even rows as =row()=even(row()) but I don't know how to make those even rows into the number format.

Thanx

Hi,

 

Assuming the cell where you want to have the formula is formatted as date, this formula formats the even rows as numbers with 0 digits and leaves alone the odd rows.

 

=IF(ROW()=EVEN(ROW()),TEXT(A1,"0"),A1)

 

Hope this is ok. Let me know if you have any questions.

 

 

 

John D and 15 other General Specialists are ready to help you