Jump to content

Office 2010 - Auto-converted Text


morocco31477

Recommended Posts

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


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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...