Results 1 to 16 of 16

Change Format of Cell into a Number (it thinks it's a date)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    146

    Change Format of Cell into a Number (it thinks it's a date)

    I am having slight trouble with the formatting of some cells. Every month I will be copying data into a row, the problem is Excel thinks it's a date instead of an integer of some sort.

    The value copied will look something like this:
    79:42:00
    (meaning 79 hours and 42 minutes)

    Excel is taking that and interpreting it as:
    1/3/1900 7:42:00 AM

    Is there an easy way to format this so Excel thinks it's a number (even if 79.7).

    I tried to change the format of the cell to "Text", but it changes it to: 3.32083333333333

    Thanks again!
    Last edited by nkitchen31; 12-15-2013 at 07:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change backwards number format to date format
    By vickie10200 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 01:32 PM
  2. Replies: 1
    Last Post: 11-01-2012, 10:37 AM
  3. Replies: 1
    Last Post: 11-29-2010, 12:10 PM
  4. Formulae to change text formatted date to number format
    By shekar goud in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2010, 01:57 PM
  5. Change cell number format in VBA
    By hemi_fan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2010, 06:05 PM

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