formula problem
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: formula problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am trying to refer to another spreadsheet in a cell (i.e. ='Sheet1'!A1). The cell I am refering to is formatted as text - I am entering a number as 055, and need it to be 055 and not 55.

    When I enter the formula into the cell, most of the time this works. However, sometimes it does not work, and refers to the formula rather than the value. So, I am seeing the actual sheet reference and not the value 055.

    The cell with the formula is NOT formatted as text.

    Any suggestions? This should not be hard at all...and is driving me crazy.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 12:26, nancyo wrote:
    The cell I am refering to is formatted as text - I am entering a number as 055, and need it to be 055 and not 55.
    I'm not convinced. Are you sure it's formatted as Text?


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, it is formatted as test. I think this is a glitch. I have another spreadsheet that I am using which is identical, and it works fine.

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi nancyo


    If you reference a cell that has been formated as Text it is very likely that the formula cell would also take on a Text format! If you would like to see leading zero's in a number use the Custom Format: 000 Just add/take zeros as needed.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Dave - Thanks!!! It worked. Sometimes it's the simple things that make my day!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com