Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel custom cell formatting

Options
  • 03-04-2014 5:16pm
    #1
    macsauce
    Registered Users Posts: 136 ✭✭


    If this is not the right forum please move to a more appropriate one.

    I am creating a dashboard in excel which is pull information from a couple of different sources in sharepoint. Because one of these is a date i have had to use the date format for the cells in the Dashboard otherwise excell does not pull/display the info correctly. When a cell is blank the dashboard displays the date as 00-Jan-00 which is distracting and confusing for people looking at it. Is there a way that i can format the cell to display the date but when the date is 00-Jan-00 to display the cell as blank?

    I would really appreciate any help given on this as i have spent a good bit of time trying to figure it our and my excel skills are not that great.

    Thanks


Comments

  • Options
    #2
    Tokyo
    Registered Users Posts: 22,655 ✭✭✭✭Tokyo


    I would imagine that rather than using the "Date" formatting, it would be better to use a custom format with rules to eliminate a zero date.

    What format is the raw date coming in from sharepoint??


  • Options
    #3
    macsauce
    Registered Users Posts: 136 ✭✭macsauce


    Thanks for the reply mike_ie. The cell is being pulled from an up formatted cell in another workbook that auto formats the date to dd mmm yy. If there is not entry in the source cell then it shows 00-Jan-00 in the destination cell. Would you by any chance know how to write that custom format to display the cell as empty when that date appears? Thanks for your help.


  • Options
    #4
    Halfbaker
    Registered Users Posts: 170 ✭✭Halfbaker


    How about an IF,ELSE function? Something like

    =IF(ISBLANK(A1),"",A1)


Advertisement