Jump to content

Welcome to MSFN Forum
Register 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


Photo

Office 2010 - Auto-converted Text

- - - - -

  • Please log in to reply
3 replies to this topic

#1
morocco31477

morocco31477

    Member

  • Member
  • PipPip
  • 100 posts
  • OS:Windows 7 x64
  • Country: Country Flag
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?


How to remove advertisement from MSFN

#2
allen2

allen2

    Not really Newbie

  • Member
  • PipPipPipPipPipPipPip
  • 1,812 posts
You need to set the cell content as text (at least in excel up to 2003).

#3
morocco31477

morocco31477

    Member

  • Member
  • PipPip
  • 100 posts
  • OS:Windows 7 x64
  • Country: Country Flag
Hmm, OK but I'm on 2010, and how would you do that anyway.

#4
morocco31477

morocco31477

    Member

  • Member
  • PipPip
  • 100 posts
  • OS:Windows 7 x64
  • Country: Country Flag
I set the cells as text, still auto-changing when I enter a colon (:)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN