Cell Format Issue

[Lloyd H. London]

I need to create a cell format so that when numbers are typed they
appear as # / #, with a slash extending from the upper right corner of
the cell to the lower left corner. I need the numbers to appear left,
slightly above the slash and right slightly below, sort of in a
superscipt,subscript orientation. I do not want the data to appear as
a fraction. I tried experimenting with custom formats, to numerous to
list. Also drawing a diagonal doesnt seem to work. It is jagged and I
cant get the numbers to appear correctly.
Any suggestions greatly appreciated.

 

[JE McGimpsey]

Try this:

1) Put a border in the cell from lower left to upper right.
2) Format the vertical alignment of the cell to "center"
3) Format the cells something like Format/Cells/Number/Custom

[<=99]0* 0;[<=999]0* 00;00* 00;@

Then, if two digits are entered, one goes on each side of the border
(assuming the cell is wide enough). If three digits are entered, the
first goes to the left, the second and third to the right, and if four
are entered, two go left, two go right.

 

[Lloyd H. London]

Works like a charm. Applied to one cell, I can copy the format to other
cells with the format painter.
One minor annoyance, the diagonal is rather jagged. Is there an easy
way, to smooth it out? If not, I will live with it.
Thanks for you help.

Try this:

1) Put a border in the cell from lower left to upper right.
2) Format the vertical alignment of the cell to "center"
3) Format the cells something like Format/Cells/Number/Custom

[<=99]0* 0;[<=999]0* 00;00* 00;@

Then, if two digits are entered, one goes on each side of the border
(assuming the cell is wide enough). If three digits are entered, the
first goes to the left, the second and third to the right, and if four
are entered, two go left, two go right.

I need to create a cell format so that when numbers are typed they
appear as # / #, with a slash extending from the upper right corner of
the cell to the lower left corner. I need the numbers to appear left,
slightly above the slash and right slightly below, sort of in a
superscipt,subscript orientation. I do not want the data to appear as
a fraction. I tried experimenting with custom formats, to numerous to
list. Also drawing a diagonal doesnt seem to work. It is jagged and I
cant get the numbers to appear correctly.
Any suggestions greatly appreciated.

 

[JE McGimpsey]

Try adjusting the border thickness and the cell width. It will probably
print better than it looks on-screen.