+ Reply to Thread
Results 1 to 4 of 4

Stop date conversion in Excel when pasting

  1. #1
    Stephanie
    Guest

    Stop date conversion in Excel when pasting

    When you type in 5/2, I know Excell will automatically convert it to 02-May.
    I know I can change the formatting of the cell, up to even using a mask. How
    do I get content I paste (i.e. from a site displaying data in a grid format),
    to NOT convert fractions to dates? Changing the content of the data from a
    website is not an option.

  2. #2
    Max
    Guest

    Re: Stop date conversion in Excel when pasting

    Perhaps try pre-formatting the cell(s) / col as Text before copy > pasting
    (via: Format > Cells > Number tab > Text > OK)
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "Stephanie" <[email protected]> wrote in message
    news:[email protected]...
    > When you type in 5/2, I know Excell will automatically convert it to

    02-May.
    > I know I can change the formatting of the cell, up to even using a mask.

    How
    > do I get content I paste (i.e. from a site displaying data in a grid

    format),
    > to NOT convert fractions to dates? Changing the content of the data from

    a
    > website is not an option.




  3. #3
    Stephanie
    Guest

    Re: Stop date conversion in Excel when pasting

    Pre-formatting the cells did not work. I had tried that. I guess the
    "pasting" overrides the cell format.

    "Max" wrote:

    > Perhaps try pre-formatting the cell(s) / col as Text before copy > pasting
    > (via: Format > Cells > Number tab > Text > OK)
    > --
    > Max
    > Singapore
    > http://savefile.com/projects/236895
    > xdemechanik
    > ---
    > "Stephanie" <[email protected]> wrote in message
    > news:[email protected]...
    > > When you type in 5/2, I know Excell will automatically convert it to

    > 02-May.
    > > I know I can change the formatting of the cell, up to even using a mask.

    > How
    > > do I get content I paste (i.e. from a site displaying data in a grid

    > format),
    > > to NOT convert fractions to dates? Changing the content of the data from

    > a
    > > website is not an option.

    >
    >
    >


  4. #4
    Max
    Guest

    Re: Stop date conversion in Excel when pasting

    "Stephanie" wrote
    > Pre-formatting the cells did not work. I had tried that.
    > I guess the "pasting" overrides the cell format.


    How about paste special > text ?
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---



+ 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