Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    41

    Unanswered: need to take the decimals out of a number..

    i have a whole column with numbers like 01.01.02.01.00.30 and what i need to do is take the decimals out so its just like 010102010030.. what i did was did search and replace, searched for the . and replace it with nothing.. but whneever i do that, it takes out the leading 0 so it'd end up like 10102010030... i think its because it thinks its a number so i changed the format to text.. but when i do search and replace it still does it... this seems really stupid sounds like theres a really easy way to do it but i just cant thinik of it right now.. any ideas?

    thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Use the substitute function. If your target cell is B3, then in C3 put this formula (and copy down the column)

    = SUBSTITUTE(B3,".","")
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •