trekcowboy
New Member
- Joined
- Mar 5, 2002
- Messages
- 9
does anyone have a formula for converting numbers to dates.
ex. 03282002 = 03/28/2002
Thanks
ex. 03282002 = 03/28/2002
Thanks
On 2002-03-28 13:26, Russell Hauf wrote:
However, 2832002 will not work.
In a nutshell, the day (mmddyyyy) or month (ddmmyyyy) must have 2 digits for these to work.
On 2002-03-28 13:55, Russell Hauf wrote:
Exactly. If they aren't entered like that then the solution is not Excel-oriented. But I've seen some interesting stuff at work that would surprise you.