+ Post New Thread
Results 1 to 5 of 5
How do you do....it? Thread, Probably an easy one....excel 2003 in Technical; Is there a way of getting rid of the first 2 digits from a set of numbers? like i have ...
  1. #1

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    London
    Posts
    5,522
    Thank Post
    2,374
    Thanked 745 Times in 456 Posts
    Blog Entries
    2
    Rep Power
    542

    Probably an easy one....excel 2003

    Is there a way of getting rid of the first 2 digits from a set of numbers? like i have 001234, 005678, 009101, 003242.

    I need to get rid of those first 2 0's from about 90 different figures. Find and replace would get rid of any like "001001". Is there a wildcard i can use or sommat?

  2. #2
    sdc
    sdc is offline
    sdc's Avatar
    Join Date
    Apr 2008
    Location
    Dorset, UK
    Posts
    312
    Thank Post
    53
    Thanked 42 Times in 37 Posts
    Rep Power
    41
    Can you format the cells as numbers? That should remove leading zeros.

  3. #3

    JJonas's Avatar
    Join Date
    Jan 2008
    Location
    North Walsham, Norfolk
    Posts
    3,090
    Thank Post
    382
    Thanked 429 Times in 318 Posts
    Rep Power
    383
    MS Excel: Right Function

    so

    =Right(A1, 4)

  4. Thanks to JJonas from:

    Little-Miss (16th January 2012)

  5. #4

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    London
    Posts
    5,522
    Thank Post
    2,374
    Thanked 745 Times in 456 Posts
    Blog Entries
    2
    Rep Power
    542
    The right function works great....but how do i do it on multiple cells as a1:a10 doesnt seem to work lol!!

  6. #5
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    693
    Thank Post
    52
    Thanked 188 Times in 124 Posts
    Rep Power
    101
    Put =Right(A1, 4) in A1 then drag down so you get =Right(A2, 4) etc. Alternatively, if they are all 6 digit numbers and all have the two leading zeros you could format the cells as custom type 0000.

  7. Thanks to clareq from:

    Little-Miss (16th January 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. Softlink Alice Library Issue - Hopefully an Easy One!
    By MyBrainHurts in forum Educational Software
    Replies: 7
    Last Post: 3rd May 2012, 07:01 PM
  2. Unable to print from Word or Excel 2003
    By pennywest in forum Windows
    Replies: 8
    Last Post: 30th November 2009, 06:41 AM
  3. Replies: 6
    Last Post: 1st February 2009, 09:11 PM
  4. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM
  5. Excel 2003 print preview discrepancy
    By danIT in forum Windows
    Replies: 1
    Last Post: 28th September 2006, 01:17 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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