morocco31477 Posted September 19, 2011 Share 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? Link to comment Share on other sites More sharing options...
allen2 Posted September 19, 2011 Share Posted September 19, 2011 You need to set the cell content as text (at least in excel up to 2003). Link to comment Share on other sites More sharing options...
morocco31477 Posted September 19, 2011 Author Share Posted September 19, 2011 Hmm, OK but I'm on 2010, and how would you do that anyway. Link to comment Share on other sites More sharing options...
morocco31477 Posted September 20, 2011 Author Share Posted September 20, 2011 I set the cells as text, still auto-changing when I enter a colon ( Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now