Results 1 to 6 of 6

Cell and Formula Bar Different

Threaded View

  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
« 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