formatting cells
 

I've tried to change to format of a cell to be general so that I can show for
example 10/35. The cell keeps reverting back to the date format. what do I
need to do so that it shows exactly as i type it?

formatting cells
 

##/## as the custom format

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"lsmith" wrote in message
...
I've tried to change to format of a cell to be general so that I can show
for
example 10/35. The cell keeps reverting back to the date format. what do I
need to do so that it shows exactly as i type it?

formatting cells
 

I tried it, but it reduced the fraction to the lowest common denominator. How
do I make show exactly as typed?

"Bob Phillips" wrote:

##/## as the custom format

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"lsmith" wrote in message
...
I've tried to change to format of a cell to be general so that I can show
for
example 10/35. The cell keeps reverting back to the date format. what do I
need to do so that it shows exactly as i type it?

formatting cells
 

Format the cell as text before you enter the data.
--
David Biddulph

"lsmith" wrote in message
...
I tried it, but it reduced the fraction to the lowest common denominator.
How
do I make show exactly as typed?

"Bob Phillips" wrote:

##/## as the custom format

"lsmith" wrote in message
...
I've tried to change to format of a cell to be general so that I can
show
for
example 10/35. The cell keeps reverting back to the date format. what
do I
need to do so that it shows exactly as i type it?