• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Sign in to follow this  
Followers 0
morocco31477

Office 2010 - Auto-converted Text

4 posts in this topic

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?

0

Share this post


Link to post
Share on other sites

You need to set the cell content as text (at least in excel up to 2003).

0

Share this post


Link to post
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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.