Date format

[Richard]

I've got my formula to subtract the dates in the
Worksheet_Change but it's not returning the format I need.
Instead of showing me: Example 6 it's showing me 38266.
How do I reformat this. Thanks

 

[Myrna Larson]

Change the number format of the cell.

 

[Guest]

I did, still won't change

-----Original Message-----
Change the number format of the cell.



.

 

[Myrna Larson]

Please post your code. You are probably returning a text value to the
worksheet.