Working with dates
On Mon, 21 Nov 2005 09:00:02 -0800, "Sandy"
wrote:
Hello
Cell A1 contains the text The date is 2005-11-21. In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!
=--(RIGHT(A1,10)
with the cell formatted (Format/Cells/Number/Custom Type:
"mm/dd/yyyy"
or
=TEXT(--(RIGHT(A1,10)),"mm/dd/yyyy")
--ron
|