Date Format

[Perkykid]

I have this formula in a cell =IF(K2="","","Check Number"&" "&J2&" "&"in the
amount of "&I2&" was mailed on "&(K2)), and on cell K2 i have the date format
as mm/dd/yy, but the result returned this "Check Number 12345 in the amount
of 258.93 was mailed on 39797." How can I change the 39797 to show 12/15/08?
Thanks.

 

[Mike H]

Try this

=IF(K2="","","Check Number"&" "&J2&" "&"in the amount of "&I2&" was mailed
on "&TEXT(K2,"mm/dd/yy"))

Mike

 

[MyVeryOwnSelf]

I have this formula in a cell =IF(K2="","","Check Number"&" "&J2&"

"&"in the amount of "&I2&" was mailed on "&(K2)), and on cell K2 i
have the date format as mm/dd/yy, but the result returned this "Check
Number 12345 in the amount of 258.93 was mailed on 39797." How can I
change the 39797 to show 12/15/08?

Instead of just K2, include this as the last part of the formula:
TEXT(K2,"mm/dd/yy")

 

[Perkykid]

it worked. Thanks a lot.

Try this

=IF(K2="","","Check Number"&" "&J2&" "&"in the amount of "&I2&" was mailed
on "&TEXT(K2,"mm/dd/yy"))

Mike

 

[Mike H]

I thought it might, glad I could help and thanks for the feedback

 

[FSt1]

hi
a date format technically is a number format and your cell that contains
the formula
=IF(K2="","","Check Number"&" "&J2&" "&"in the amount of "&I2&" was mailed
on "&(K2)) retuns text. you cann't apply a number format to text.
solution. incorperate the format in the formula.....
=IF(K2="","","Check Number"&" "&J2&" "&"in the amount of "&I2&" was mailed
on "&Text(K2, "mm/dd/yy"))

note that portion of the formula that refers to k2 not is....
text(k2, "mm/d/yy")

regards
FSt1