+ Reply to Thread
Results 1 to 7 of 7

not print result formulas

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    not print result formulas

    Hello everyone and happy easter.
    In the workbook attachaments is annex a calendar.
    You can not display during the print day 29/30/31?
    Are hidden from the conditional formatting.
    The workbook must be printed in B / N.
    I hope I explained.
    A greeting,
    max_max
    -----------------------------------------------------
    Ciao a tutti e buona pasqua.
    nel workbook allegato è inserito un calendario.
    E' possibile durante la stampa non visualizzare i giorni 29/30/31 ?
    Sono nascosti dalla formattazione condizionale.
    Il workbook deve essere stampato in B/N.
    Un saluto,
    max_max

    calendar.xls

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: not print result formulas

    Start E3
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Then the folowing cells
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    all the way to AI3
    DateFormula.jpg
    Attached Files Attached Files
    Last edited by davesexcel; 04-05-2015 at 09:12 AM.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: not print result formulas

    Thanks davesexcel is ok !!!
    Can be a change to the days of the range E4:AI4?
    dom / lun / mar / mer / gio / ven / sab
    must become:
    do / lu / ma / me / gi / ve / sa
    only two letters.
    I have tried:
    =PROPER(LEFT(TEXT(E3,"ggg"),2))
    works pretty well but then formatting to color the days do not work.
    Greetings from Italy.
    max_max
    ----------------------------------------------------------------------------------------
    Grazie davesexcel è ok!!!
    è possibile una modifica ai giorni del range E4:AI4?
    dom/lun/mar/mer/gio/ven/sab
    deve diventare:
    do/lu/ma/me/gi/ve/sa
    solo 2 lettere.
    Ho provato:
    =MAIUSC.INIZ(SINISTRA(TESTO(E3;"ggg");2))
    funziona abbastanza bene ma poi le formattazioni per colorare i giorni non funzionano.
    Un saluto dall'Italia.
    max_max

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: not print result formulas

    You probably can't format the cell as "dd" because it becomes numbers.

    Use this

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: not print result formulas

    Thanks davesexcel the days have become two letters.
    Unfortunately, the formula for coloring Sunday:
    = WEEKDAY (E3) = 1
    with two letters will not work.
    max_max
    -------------------------------------------------------
    Grazie davesexcel i giorni sono diventati a due lettere.
    Purtroppo la formula per colorare la domenica:
    =GIORNO.SETTIMANA(E3)=1
    con due lettere non funziona.
    max_max

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: not print result formulas

    O ya, i guess you will have to deal with 3 letters

  7. #7
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: not print result formulas

    No matter I leave 3 letters.
    Thanks again for editing for print.
    max_max
    ---------------------------------------------------
    Non importa lascio 3 lettere.
    Ti ringrazio ancora per la modifica per la stampa.
    max_max

+ 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. [SOLVED] Export result of Debug.Print to a MsgBox
    By Jimmy P in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 04:11 PM
  2. [SOLVED] print result cards automatically from result sheet
    By excellover2212 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-25-2014, 05:24 PM
  3. Replies: 5
    Last Post: 01-31-2013, 12:55 PM
  4. How To Print Calculation Result In New Cell
    By marello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2011, 07:49 AM
  5. print command button result in cell
    By Shadow103 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2010, 02:59 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