is there anyway that I can print different dates within a worksheet? I'm updating only one page within a worksheet and would like to see revised mm/dd/yy on that one page only.
is there anyway that I can print different dates within a worksheet? I'm updating only one page within a worksheet and would like to see revised mm/dd/yy on that one page only.
I don't understand what you want to do. Are you saying that you want the
format of the date (mm/dd/yy vs dd/mm/yy) a certain way on that one sheet?
Just format the cells of that one sheet the way you like the date to show.
Select the cells and do Format - Cells - Number - Date and select the format
you want. Post back if this isn't your problem. HTH Otto
"kitchur" <[email protected]> wrote in
message news:[email protected]...
>
> is there anyway that I can print different dates within a worksheet? I'm
> updating only one page within a worksheet and would like to see revised
> mm/dd/yy on that one page only.
>
>
> --
> kitchur
> ------------------------------------------------------------------------
> kitchur's Profile:
> http://www.excelforum.com/member.php...o&userid=33165
> View this thread: http://www.excelforum.com/showthread...hreadid=529852
>
sorry, I really should have explained a little more. I'm using the custom footers. I've created on the right section of the footer a manually entered permanent date, then used the sheet name and page # buttons, as I don't want this section of the footer to ever change. (no new pages should ever have to be added.. famous last words)
Now in the center section under custom footers, I've entered "revised" with the date button.
Now within the worksheet say 15 pages, I've only updated page 5. I was hoping that this center section would only flag this one updated page. Not the case as this section footer printed the revised date footer on all 15 pages!
I did also then try entering in the bottom page/cell line the actual "revised and date" that I wanted, but it just doesn't look professional.
just another mention of importance is that on any page within the worksheet that is revised, I will need to keep that revision date on that page, until it is revised again, thus there is a great chance of all 15 pages either having different revision dates or no revision dates at all.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks