When I change the style in column (a) a date, it also changes colu
 

When I change the style in column (a) a date, it also changes column (b)
which I want to be the time
-
Wayne

Hi Wayne

not sure how/why this is happening ... what is actually in cell A1 in B1.
How are you changing the style in column A and what is the version of excel
you're running.

Cheers
JulieD


"Wayne" wrote in message
...
When I change the style in column (a) a date, it also changes column (b)
which I want to be the time
-
Wayne

6I am making up a simple spread sheet. Column a has the date, year, day style
formated. In column b I want to put time of day (8:00 AM). When I format all
of column b to the above style of time it changes column a also. Or if I have
b done the way I want it and format "a" with the style (Thursday, June 30,
2005) it changes "b" to that style. I have used Works before I got this
excell and I could format each cell if I wanted to without affecting the
adjacent cell or column. I am using Excell 2003 ver 11.6355 6360 with sp1.

Thank you for you help.
) or some

"JulieD" wrote:

Hi Wayne

not sure how/why this is happening ... what is actually in cell A1 in B1.
How are you changing the style in column A and what is the version of excel
you're running.

Cheers
JulieD


"Wayne" wrote in message
...
When I change the style in column (a) a date, it also changes column (b)
which I want to be the time
-
Wayne

Hi Wayne

i've never seen the behaviour you're describing - if you'ld like to zip up
the workbook and email it direct (julied_ng at hctsdot net dot au) to me
i'll be happy to take a look at it.

Cheers
JulieD



"Wayne" wrote in message
...
6I am making up a simple spread sheet. Column a has the date, year, day
style
formated. In column b I want to put time of day (8:00 AM). When I format
all
of column b to the above style of time it changes column a also. Or if I
have
b done the way I want it and format "a" with the style (Thursday, June 30,
2005) it changes "b" to that style. I have used Works before I got this
excell and I could format each cell if I wanted to without affecting the
adjacent cell or column. I am using Excell 2003 ver 11.6355 6360 with sp1.

Thank you for you help.
) or some

"JulieD" wrote:

Hi Wayne

not sure how/why this is happening ... what is actually in cell A1 in B1.
How are you changing the style in column A and what is the version of
excel
you're running.

Cheers
JulieD


"Wayne" wrote in message
...
When I change the style in column (a) a date, it also changes column
(b)
which I want to be the time
-
Wayne

Hi Wayne

i've just seen Gord's post to you over in "newusers" - have you tried his
suggestion - did it work

Cheers
JulieD

"Wayne" wrote in message
...
6I am making up a simple spread sheet. Column a has the date, year, day
style
formated. In column b I want to put time of day (8:00 AM). When I format
all
of column b to the above style of time it changes column a also. Or if I
have
b done the way I want it and format "a" with the style (Thursday, June 30,
2005) it changes "b" to that style. I have used Works before I got this
excell and I could format each cell if I wanted to without affecting the
adjacent cell or column. I am using Excell 2003 ver 11.6355 6360 with sp1.

Thank you for you help.
) or some

"JulieD" wrote:

Hi Wayne

not sure how/why this is happening ... what is actually in cell A1 in B1.
How are you changing the style in column A and what is the version of
excel
you're running.

Cheers
JulieD


"Wayne" wrote in message
...
When I change the style in column (a) a date, it also changes column
(b)
which I want to be the time
-
Wayne