Prev: How to display a date
Next: Sorry for the double posts here
From: Barry on 30 Mar 2010 22:46
I'm using Excel 2003 Sp3

I'd like to display the date entered in cell H3 in cell I3 in the following
format:

20100331215045

2010 year
03 month
31 day
2150 hour and minute
45 the seconds

I'm sure there's a formula there somewhere......LOL


Thanks in advance,

Barry


From: teylyn on 30 Mar 2010 23:14

Hi, format the cell with custom format

yyyyMMddhhmmss





B
a
r
r
y
;
6
8
6
4
2
5

W
r
o
t
e
:


>
I'm using Excel 2003 Sp3
>
> I'd like to display the date entered in cell H3 in cell I3 in the
following
> format:
>
> 20100331215045
>
> 2010 year
> 03 month
> 31 day
> 2150 hour and minute
> 45 the seconds
>
> I'm sure there's a formula there somewhere......LOL
>
>
> Thanks in advance,
>
> Barry


--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=191834

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: How to display a date
Next: Sorry for the double posts here