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
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