Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109532
| From | isabelle <i@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Convert date/time to serial number and compare serial numbers |
| Date | 2016-11-04 12:10 -0400 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <nvibtl$1a8u$1@gioia.aioe.org> (permalink) |
| References | <98547fda-134a-4767-b2e8-1b9ea37e2d6e@googlegroups.com> <051a820b-32d1-44a6-8c95-03fb7b961fee@googlegroups.com> <nviaq4$188c$1@gioia.aioe.org> |
if you don't want the formula but only the value
With Range("B1")
.Value = DateSerial(Left(Cells(1, 1), 4), Mid(Cells(1, 1), 6, 2), Mid(Cells(1,
1), 9, 2)) + CDate(Right(Cells(1, 1), 8))
.NumberFormat = "General"
'or
'.NumberFormat = "yyyy/mm/dd hh:mm:ss"
End With
isabelle
Le 2016-11-04 à 11:51, isabelle a écrit :
> also,
>
> With Range("B1")
> .Formula = "=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+RIGHT(A1,8)"
> .NumberFormat = "General"
> 'or
> '.NumberFormat = "yyyy/mm/dd hh:mm:ss"
> End With
>
> isabelle
>
> Le 2016-11-04 à 10:59, GARYWC a écrit :
>> The cells have a text format.
>>
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-03 15:35 -0700
Re: Convert date/time to serial number and compare serial numbers "Auric__" <not.my.real@email.address> - 2016-11-04 04:19 +0000
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-03 22:05 -0700
Re: Convert date/time to serial number and compare serial numbers "Peter T" <askformy@gmail.com> - 2016-11-04 08:20 +0000
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 07:59 -0700
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 11:51 -0400
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 12:10 -0400
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 11:54 -0400
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 10:57 -0700
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 14:44 -0400
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 15:45 -0400
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 12:15 -0700
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 14:53 -0700
csiph-web