Help Please

[Janet Bullard]

Following is a query I sent to Microsoft who have told me
that the product (Excel 97) is classified as obsolete and
has been superceded. Anyone out there who can help I'd
be grateful.

We are trying to find out how to split a cell diagonally
in Excel to allow for inputting of overlapping data
(different data). We are putting together a monthly
training program where 2 training activities overlap and
we want to be able to have this information in one row
instead of having to add extra rows for every over-
lapping activity. We know that we can insert a diagonal
line into a cell by using borders however it doesn't
actually split the cell which is what we want to do.

Thank you very much for your assistance.

Cheers,
Janet Bullard
Sydney, Australia

 

[David McRitchie]

Hi Janet,
It's not very pretty but it might work for you.
Formatting to split a number to left and right of a cell, J.E.McGimpsey, 2004-02-07.
http://google.com/groups?threadm=jemcgimpsey-32EEF4.06432707022004@msnews.microsoft.com

if that link breaks up look for diagonal in
http://www.mvps.org/dmcritchie/excel/formula.htm

 

[Janet Bullard]

Hi David,

Thanks a lot - we'll try it out and I'll let you know how
we get on.

Cheers,
Janet

Janet Bullard,
Sydney, Australia

-----Original Message-----
Hi Janet,
It's not very pretty but it might work for you.
Formatting to split a number to left and right of a

cell, J.E.McGimpsey, 2004-02-07.

http://google.com/groups?threadm=jemcgimpsey- (e-mail address removed)

if that link breaks up look for diagonal in
http://www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Following is a query I sent to Microsoft who have told me
that the product (Excel 97) is classified as obsolete and
has been superceded. Anyone out there who can help I'd
be grateful.

We are trying to find out how to split a cell diagonally
in Excel to allow for inputting of overlapping data
(different data). We are putting together a monthly
training program where 2 training activities overlap and
we want to be able to have this information in one row
instead of having to add extra rows for every over-
lapping activity. We know that we can insert a diagonal
line into a cell by using borders however it doesn't
actually split the cell which is what we want to do.

Thank you very much for your assistance.

Cheers,
Janet Bullard
Sydney, Australia

.