+ Reply to Thread
Results 1 to 4 of 4

1 miss click, hours are now numbers

  1. #1
    Registered User
    Join Date
    04-23-2020
    Location
    Belgium
    MS-Off Ver
    latest version
    Posts
    1

    Exclamation 1 miss click, hours are now numbers

    Greetings Everyone


    I am very new to this forum, so if I post something in the wrong place or in the wrong way, forgive me.

    With that out of the way, here is the problem. I use excel mostly for keeping track of my tasks and projects. I also use it as a time table. I was on the phone and meanwhile tried to write something down. Apparently I miss clicked somewhere on the right side of my keyboard (close to the Numpad). The whole excel tab stretched out, and my hours became decimal numbers below 1. So Instead of 10 o'clock I now have 0,4166666... It is probably very easily fixed, but how?


    Kind regards and thanks a bunch!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,816

    Re: 1 miss click, hours are now numbers

    Hi and welcome
    reformat your cell to h:mm or whatever your original format was. 0.416666 is the same as 10 o'clock as one day is 1 to XL so 10 hours is 10/24

  3. #3
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,566

    Re: 1 miss click, hours are now numbers

    Some how it would appear the cell has re-formatted.
    0.4166666 is equivalent to 10.00 am try formatting the cell 'HH:MM'

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    3,979

    Re: 1 miss click, hours are now numbers

    Hi there,

    Try: File >> Options >> Advanced

    Scroll down to the section "Display options for this worksheet" and uncheck the box which says "Show formulas in cells instead of their calculated results"

    (I think you may have accidentally pressed Ctrl + the "funny slanted apostrophe" key, i.e. ASCII code 96)

    Hope this helps.

    Regards,

    Greg M
    Last edited by Greg M; 04-23-2020 at 08:25 PM. Reason: ASCII code added

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hello I am Miss Bad Wolf
    By Miss Bad Wolf in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 08-22-2018, 06:05 AM
  2. Change the Time value if it is < 9 hours or >13 hours upon click checkbox
    By pradyumnajpn10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2015, 02:14 AM
  3. Replies: 13
    Last Post: 05-03-2013, 08:42 PM
  4. type miss match
    By newapa in forum Excel General
    Replies: 1
    Last Post: 09-24-2012, 01:30 PM
  5. vlookup - hit & miss!!
    By rac1974 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-23-2007, 12:06 AM
  6. [SOLVED] how to add hours and show actual hours not decimal numbers
    By TWERNER in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-21-2006, 03:40 AM
  7. [SOLVED] One thing I miss: double right click
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2005, 06:06 AM

Tags for this Thread

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