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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.