Prev: macro chart creation
Next: How do I remove the PAGE 1 from an excell worksheet?
From: EricG on 21 May 2010 15:57
"but I wanted to not have to enter the date as well"

Understood, but a time with no date can be misinterpreted, as you have seen,
at the crossover points. Perhaps you can figure out a way to get this other
program to spit out the date as well.

Good luck,

Eric

"Norm" wrote:

> These two worked for me ,Thank You..... but I wanted to not have to enter the
> date as well , the times will come from another program that exports them to
> Excel and the idea was to cut and paste them in
>

From: Ron Rosenfeld on 21 May 2010 15:56
On Fri, 21 May 2010 10:06:12 -0700, Norm <Norm(a)discussions.microsoft.com>
wrote:

>I did have a problem using the 1904 date system mostly because I have no
>knowledge of how that works or is set up
>Cheers!!

Depending on your version of Excel, it will be either under Tools/Options; or
in the Excel Options area of Excel 2007+

If you don't enter dates and times, unless you have some maximum amount of time
a shipment can be early or late, there will be ambiguity.
--ron
First  |  Prev  | 
Pages: 1 2
Prev: macro chart creation
Next: How do I remove the PAGE 1 from an excell worksheet?