Automatically format

Discussion in 'Microsoft Excel New Users' started by Abrielle, Feb 4, 2011.

  1. Abrielle

    Abrielle Guest

    I have a workbook for personal banking purposes. When I log on to my bank, I
    copy the latest lines of my statement and paste into my workbook.

    I use Paste Special | Unicode text and my columns are filled appropriately.

    The only problem is that the last column, i.e. the balance, does not format
    to two decimal places as I had already set up.

    How can I automatically paste in the right format, please? Do I need a
    macro?
     
    Abrielle, Feb 4, 2011
    #1
    1. Advertisements

  2. Abrielle

    Jim Cone Guest

    After pasting your data:
    Select the entire column (click the column heading)
    Find the button on the "Home" tab (xl2007) or on a toolbar (xl2003) that looks somewhat
    like that below...
    ----
    <.0
    ..00
    ----
    Clicking it (or its companion) will quickly adjust the display of decimals.

    -or-
    Paste your data into "Notepad" copy it again and paste into Excel.
    --
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (Extras for Excel add-in: convenience built-in)




    "Abrielle" <>
    wrote in message
    news:iighfh$ngi$-september.org...
    >I have a workbook for personal banking purposes. When I log on to my bank, I copy the
    >latest lines of my statement and paste into my workbook.
    >
    > I use Paste Special | Unicode text and my columns are filled appropriately.
    >
    > The only problem is that the last column, i.e. the balance, does not format to two
    > decimal places as I had already set up.
    >
    > How can I automatically paste in the right format, please? Do I need a macro?
     
    Jim Cone, Feb 4, 2011
    #2
    1. Advertisements

  3. Abrielle

    Abrielle Guest

    Thank you.

    "Jim Cone" wrote in message news:iih09g$mos$-september.org...

    After pasting your data:
    Select the entire column (click the column heading)
    Find the button on the "Home" tab (xl2007) or on a toolbar (xl2003) that
    looks somewhat
    like that below...
    ----
    <.0
    ..00
    ----
    Clicking it (or its companion) will quickly adjust the display of decimals.

    -or-
    Paste your data into "Notepad" copy it again and paste into Excel.
    --
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (Extras for Excel add-in: convenience built-in)




    "Abrielle" <>
    wrote in message
    news:iighfh$ngi$-september.org...
    >I have a workbook for personal banking purposes. When I log on to my bank,
    >I copy the latest lines of my statement and paste into my workbook.
    >
    > I use Paste Special | Unicode text and my columns are filled
    > appropriately.
    >
    > The only problem is that the last column, i.e. the balance, does not
    > format to two decimal places as I had already set up.
    >
    > How can I automatically paste in the right format, please? Do I need a
    > macro?
     
    Abrielle, Feb 4, 2011
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Frank Bahrenhorst

    how to make cells automatically format to entered text size?

    Frank Bahrenhorst, Jun 28, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    262
    Frank Barenhorst
    Jun 29, 2004
  2. Guest

    How do I format a number in a currency format in word

    Guest, Sep 14, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    1,319
    Dave Peterson
    Sep 15, 2004
  3. Guest

    How do i change numbers in text format to number format?

    Guest, Dec 14, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    244
    Frank Kabel
    Dec 14, 2004
  4. Guest

    Data Format: how can I re-format

    Guest, Dec 27, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    166
    Guest
    Dec 28, 2004
  5. Guest
    Replies:
    1
    Views:
    701
    JE McGimpsey
    Jan 31, 2005
Loading...

Share This Page