Prev: What is the formula to Round an average to the nearest 100
Next: excel: How to set up a formula for a range of numbers ie. 3.5-5..
From: SherryS on 26 Apr 2010 23:40
When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these numbers into dates?

From: Jacob Skaria on 27 Apr 2010 00:25
If your Windows Regional Settings recognise a format of mddyyyy, you can
apply the below formula and format the formula cell to date..

=--TEXT(A1,"00\-00\-0000")

--
Jacob (MVP - Excel)


"SherryS" wrote:

> When importing from payroll, it gives me all dates formatted as general
> numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
> convert these numbers into dates?
>
From: Teethless mama on 27 Apr 2010 08:34
=--TEXT(A1,"00-00-0000")


"SherryS" wrote:

> When importing from payroll, it gives me all dates formatted as general
> numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
> convert these numbers into dates?
>
 | 
Pages: 1
Prev: What is the formula to Round an average to the nearest 100
Next: excel: How to set up a formula for a range of numbers ie. 3.5-5..