Results 1 to 5 of 5

EXCEL 2003 right function not recognising <100

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    Brisbane
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cool EXCEL 2003 right function not recognising <100

    hi
    I am running a spreedsheet based around various reports.
    each repot has it's own name & number which increases in increments of 1.
    I use the mid function to as a calculator to alter report numbers.
    this works fine after 100 but for numbers not of three digits it returns only 2
    ie stop.001 returns stop.02(not stop.002)
    the formula i use is
    1. first cell A30 = stop."&"015" (this is a manual field)
    2. second cell = "stop."&(RIGHT(A30,3)+1
    can someone please explain what the problem is
    thank in advance
    Rayo
    Last edited by Rayo; 01-01-2013 at 10:28 PM.

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1