Posted to microsoft.public.excel.worksheet.functions

theresa317 theresa317 is offline

external usenet poster

Posts: 1

Date Formatting

I received a worksheet from someone with the date stated as a number. ie..
100364, 80763. These are actual dates without any formatting(/ -). I need a
formula that will insert a "/". 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
conditional formatting for cell date to equal today's date	Sistereinstein	Excel Worksheet Functions	2	September 10th 12 07:53 PM
Date Formatting	catfish	Excel Worksheet Functions	2	August 2nd 07 08:37 PM
Formatting as date	gwplotts via OfficeKB.com	Excel Worksheet Functions	3	April 17th 07 03:09 PM
Date formatting	nick	Excel Discussion (Misc queries)	7	May 10th 06 06:04 PM
Formatting the date	nick	Excel Discussion (Misc queries)	1	May 10th 06 04:01 PM

All times are GMT +1. The time now is 03:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us