morocco31477 Posted September 19, 2011 Posted September 19, 2011 Hey guys. In Excel, I'm trying to change a lot of cells that have a format of #### ## into ####:## (add a colon). When I do that, on some of them, it's turning into something else. Here's an example:0436 03 --> 0436:03 --> Excel then turns this into 436:03:00.Anyone know how to stop this so that I can just make it 0436:03?
allen2 Posted September 19, 2011 Posted September 19, 2011 You need to set the cell content as text (at least in excel up to 2003).
morocco31477 Posted September 19, 2011 Author Posted September 19, 2011 Hmm, OK but I'm on 2010, and how would you do that anyway.
morocco31477 Posted September 20, 2011 Author Posted September 20, 2011 I set the cells as text, still auto-changing when I enter a colon (
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now