Posted to microsoft.public.excel.worksheet.functions

Sandy

Posts: n/a

Working with dates

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to find the working days difference between to dates?	Mudgeman	Excel Discussion (Misc queries)	2	May 15th 06 04:26 AM
Line Chart with dates in 5 day working week only	Danger	Charts and Charting in Excel	2	September 20th 05 09:31 AM
working with dates	Pe66les	Excel Worksheet Functions	3	August 25th 05 12:19 AM
working with dates	Phil kelly	Excel Discussion (Misc queries)	2	June 21st 05 12:05 PM
Is there a way to calculate business working days between dates i.	hjyoungii	Excel Worksheet Functions	2	February 23rd 05 04:25 PM

All times are GMT +1. The time now is 07:10 PM.

About Us

"It's about Microsoft Excel"