Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Hi all,

    I have a cell that within the cell the value repeats itself. I have tried many things to correct, checked the conditional formatting, there is none, checked everthing that I can think of, even tried to disable MAcros, but nothing has worked so far and I thought maybe one of the experts would know what might happening cause I am out of answers.

    Thank you,
    Darryl.
    Attached Images Attached Images

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    What is the number format for the cell?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Can you post a sanitized version of your workbook?
    Regards
    Don

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by HUHandEH View Post
    Hi all,

    I have a cell that within the cell the value repeats itself. I have tried many things to correct, checked the conditional formatting, there is none, checked everthing that I can think of, even tried to disable MAcros, but nothing has worked so far and I thought maybe one of the experts would know what might happening cause I am out of answers.

    Thank you,
    Darryl.
    I suspect that your cell has first been formatted as Text; then custom formatted "@@@@@", without the quotes.

    Try:
    Edit > Clear > Formats
    Regards
    Don

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If the number of 4s increases/decreases as the column width is altered, then I suspect a number format involving an asterisk.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    If then number of 4s increases/decreases as the column width is altered, then I suspect a number format involving an asterisk.
    You guys really are experts!

    I changed the format of the cell to General, and input the value and it is ok now,

    Thanks,
    Darryl.

Posting Permissions

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