Hi Paul,
Yes, this us what I was looking for. After not getting any replies from
anyone (and spending way too much time on it), I also came up with a
similar solution.
1. TEXT(A1,"yymmdd")
2. The in adjacent cell =A1*1
Thank you.
On Wednesday, 8 June 2016 20:09:53 UTC-4, Bill Q wrote:
>
>
I'm not sure what you mean by "just the numeric", other than perhaps you mean
you'd like to convert the date format 20160606 to a NUMBER.
first, keep in mind that it's ALREADY a number.An Excel "date" is the number of
days since 1/1/1900 DISPLAYED in the requested format (i.e. DDMM)So, to
"c
Anyone ??
On Wednesday, 8 June 2016 20:09:53 UTC-4, Bill Q wrote:
>
> Hi,
>
> PSA.
>
> Column "A" = source.date.
> Column "B" = source date converted to special date form MMDD
>
> I would like column "C" to be just the numeric. .
>
> I have tried just about everything.
>
> Cannot figure th
