+ 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)

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