When I type 4-9 or 10-19 into a cell it converts it into a date (9th of April, 19th of October). I just want to leave it as a number, so how do I disable the date conversion?
right click on the cell, go to Format and set the format of the cell from there, i.e. number, not date.
[IMG]http://i36.tinypic.com/efm7ow.jpg[/IMG]
[editline]07:54PM[/editline]
Damn automerge ninja.
[editline]07:56PM[/editline]
[IMG]http://i38.tinypic.com/1z71o48.jpg[/IMG]
Which one do I choose?
[editline]07:59PM[/editline]
Doesn't matter, I fixed it, lock this thread please.
Sorry, you need to Log In to post a reply to this thread.
