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?
Welcome to MSFN ForumRegister now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account
Office 2010 - Auto-converted Text
Posted 19 September 2011 - 12:38 PM
Posted 19 September 2011 - 02:04 PM
You need to set the cell content as text (at least in excel up to 2003).
Posted 19 September 2011 - 02:42 PM
Hmm, OK but I'm on 2010, and how would you do that anyway.
Posted 20 September 2011 - 07:07 AM
I set the cells as text, still auto-changing when I enter a colon (
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users