hi, i fill out a report every day and in a certain row I want to type stuff like:
1-2
3-5
5-10
just examples...
of course every time I get 2-Jan for the 1-2 ... so I go to cell formatting and select "Number" and try typing 1-2 in again and then I get 41276 ... I then give up and type '1-2 and it works, but do I really need to go through this every time, can't I format the cell so that when I freaking type 1-2 it says 1-2 ?????!!!
thanks
Bookmarks