I ian Jul 28, 2004 #1 How do i make it so that when i enter 06/04 in a cell ot does not revert to 6-Apr?
G Guest Jul 28, 2004 #2 Hi Either precede the entry with a ' or format the cell as text before you type it in.