Format the cell as fraction (up to 1 digit), or custom # ?/?
--
David Biddulph

"m.beebee" wrote in message
...
....
2) secondly i sometimes need to have a cell that says 3/4 or 1/2 without
it
automatically chaging this to a date. how do i switch this off?