+ Reply to Thread
Results 1 to 6 of 6

Cell and Formula Bar Different

  1. 06-24-2021, 04:04 AM #1
    john_berman
    john_berman is offline
    Registered User
    Join Date
    03-08-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    44

    Cell and Formula Bar Different

    Hi
    I'm sure this is obvious but I don't understand why the data shown in the cell is differs to the formula bar ?



    What should be in B1 is: 06:59:14.9

    Pointers really appreciated

    CSV Attached

    Kind Regards
    John B

    excel.JPG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-24-2021, 04:15 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,466

    Re: Cell and Formula Bar Different

    Please update your profile with your current version of Excel.

    Your bespoke formatting for that cell is mm:ss.0. This affects what you see in the cell, but the formula bar shows the underlying (real) value.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-24-2021, 04:15 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Cell and Formula Bar Different

    B1 has been formatted as mm:ss.0

    So... you are seeing the minutes:seconds:decimal seconds. There are NO hours in the CSV that you uploaded, so even if it is changed to hh:mm:ss format on the CSV it just shows 09:59:15

    So, I can not reproduce your issue in full.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  4. 06-24-2021, 04:19 AM #4
    john_berman
    john_berman is offline
    Registered User
    Join Date
    03-08-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    44

    Re: Cell and Formula Bar Different

    Hi

    Thanks, i see the point about the formal of the cell etc and now that I have changed the cell format all is well

    Thanks

    John B
    Reply With QuoteRegister To Reply
  5. 06-24-2021, 04:21 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Cell and Formula Bar Different

    You're welcome.


    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  6. 06-24-2021, 04:24 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,466

    Re: Cell and Formula Bar Different

    Pleasure.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help Copying Formula from another cell, modifying formula and then pasting to new cell
    By TygerG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2021, 02:05 PM
  2. [SOLVED] If cell has a formula, copy text to TextBox and leave formula unchanged in cell
    By yachrishere in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2016, 06:26 PM
  3. Formula Help - nested statements - different things if cell blank or cell part of formula
    By hirshy1230 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2016, 03:53 PM
  4. [SOLVED] Formula to return Blank cell if referenced cell has no entries, if not use formula
    By stpeter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2016, 01:41 PM
  5. [SOLVED] Enter formula result from one cell into a COUNTIF formula in another cell. Help please!
    By gregrach in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 11:23 AM
  6. [SOLVED] Retaining formula cell references when copying a formula to a different cell
    By FrankParisi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2013, 07:05 AM
  7. populate cell with formula referenced from array, insert adjacent cell value into formula
    By globalfuture in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 08:34 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1