+ Reply to Thread
Results 1 to 3 of 3

All empty cells in the spreadsheet formatted as time

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    LA
    MS-Off Ver
    2010
    Posts
    6

    All empty cells in the spreadsheet formatted as time

    For some inexplicable reason all empty cells in my multi tab dashboard spreadsheet are formatted as time. When mouse over on some series in graphs value shows as time too. Moreover, when exploding pivot into detail worksheet every single value in that detail sheet is formatted as time too. Has anyone experienced such annoyance? Had I inadvertently changed default formatting for the file to be the "time"?

    Greatly appreciate any feedback.

    Thanks,
    Igor

  2. #2
    Registered User
    Join Date
    09-17-2014
    Location
    LA
    MS-Off Ver
    2010
    Posts
    6

    Re: All empty cells in the spreadsheet formatted as time

    Capture.PNG

    An example of pivot detail, have to change all columns to corresponding data format to be able to use it...

  3. #3
    Registered User
    Join Date
    09-17-2014
    Location
    LA
    MS-Off Ver
    2010
    Posts
    6

    Post Re: All empty cells in the spreadsheet formatted as time- resolved

    The cause - style "Normal" corrupted through imports. Found the utility that resolved the issue here: http://sergeig888.wordpress.com/2011...now-available/

+ 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. Formula to indicate overlap of time formatted cells?
    By Moonbather in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2013, 03:42 PM
  2. Replies: 4
    Last Post: 06-07-2013, 03:09 AM
  3. How to totalise time formatted cells
    By olafurbj in forum Excel General
    Replies: 13
    Last Post: 09-16-2011, 12:32 PM
  4. Add values to time formatted cells
    By Chutney in forum Excel General
    Replies: 1
    Last Post: 11-30-2009, 07:52 AM
  5. [SOLVED] querying a spreadsheet with formatted cells using ado
    By J.D. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2006, 02:35 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