+ Reply to Thread
Results 1 to 2 of 2

How do I stop a timestamp being printed to paper next to my date column.

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Whitstable
    MS-Off Ver
    Excel 2003
    Posts
    1

    How do I stop a timestamp being printed to paper next to my date column.

    Hi all,

    Im an intermediate excel user, working on excel 2010 on winxp. I have a problem where when my worksheet is printed, the time (00:00:00) is printed next to the date (xx/xx/xxxx) in a column. I need to know how to remove this timestamp, and I have tried formatting the cell with every one of the different formats, including the custom date formats. Ive looked this up on google first, and there are lots of results on how to do a timestamp, how to remove one from the actual date column (text to columns etc) but nothing specific on how to stop it - printing - the timestamp.

    Any help on this matter would be greatly appreciated.

    Many thanks,

    Matt Harris

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How do I stop a timestamp being printed to paper next to my date column.

    is it a real date /time ie if you format it dd/mm/yyyy does the time go away? what does the actual time stamp look like? have you tried putting 0 in a spare cell copying it then select a range of date/times and paste special -add.Or select text to columns skip through til you can choose dmy then click finish
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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