Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lambodar Eng.   on Nov 21 In MS Office Category.

  
Question Answered By: Daya Sharma   on Nov 21

Problem is - a date  IS a number. Any number (within reason) can be
formatted as a date. And any date can be formatted as a number.

Ask it for its format ...

=CELL("format",$A4)

if the string  returned starts with "D" then Excel believes it is a date (or
at least, that it is formatted as a date).

Share: 

 
 
Didn't find what you were looking for? Find more on Determine the data type of a cell Or get search suggestion and latest updates.


Tagged: