+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : converting Dollar to Cent for complete column

  1. #1
    Registered User
    Join Date
    03-01-2009
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    12

    converting Dollar to Cent for complete column

    Hi.
    here is the Column of dollar $ which i want to convert:
    ( a small list from a column )

    This is an example for Dollar $ :
    0.0168
    0.1934
    0.0996
    0.1166
    0.0553
    0.0562
    0.0395
    0.0381

    which i want to convert like this:

    This is an example for Cent of above mentioned Dollars $ :

    1.68
    19.34
    9.996
    11.66
    5.53
    5.62
    3.95
    3.81


    Deleting start "0" and Decimal and putting the decimal after cent.
    For example:

    From 0.0168 to 1.68

    How do i do that and how do i do that for complete column ?

    Sorry i am newbie here if msitaken rules.
    Thanx
    Last edited by everfresh1; 03-01-2009 at 03:42 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: converting Dollar to Cent for complete column

    Enter the value 100 in a blank cell, copy the cell, highlight your values -> Edit -> Paste Special -> Operation: Multiply

    This will convert all of your values simultaneously.

+ 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