+ Reply to Thread
Results 1 to 6 of 6

Vba convert values to numbers and put currency in front of the values

  1. #1
    Registered User
    Join Date
    05-16-2016
    Location
    bangalore,India
    MS-Off Ver
    2013
    Posts
    32

    Vba convert values to numbers and put currency in front of the values

    Hello,

    I am not able to convert values to numbers for the Columns A to F. Also i want to add currency $ in front of all the values and align them to center.

    nofrmt.PNG

    Below is the code :

    Please Login or Register  to view this content.

    Thank You!

    Regards
    Wither
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Vba convert values to numbers and put currency in front of the values

    Your numbers are formatted as text.

    Go to the data tab on the excel ribbon.

    Select column A.

    On the ribbon, click Text to columns, then click finish.

    Repeat for each column.

    Now apply your formats as normal.

  3. #3
    Registered User
    Join Date
    05-16-2016
    Location
    bangalore,India
    MS-Off Ver
    2013
    Posts
    32

    Re: Vba convert values to numbers and put currency in front of the values

    Hello jason,

    can it be done through macro as i wouldn't need to do manually for n no of files.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Vba convert values to numbers and put currency in front of the values

    Try:
    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Registered User
    Join Date
    05-16-2016
    Location
    bangalore,India
    MS-Off Ver
    2013
    Posts
    32

    Re: Vba convert values to numbers and put currency in front of the values

    Thanks xladept it works ! .

    Also ,how to align the values in column A to F in center?

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Vba convert values to numbers and put currency in front of the values

    You're welcome and thanks for the rep! - Try this:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert numbers to words (Currency)
    By nancyching1711 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2015, 08:38 AM
  2. To convert the numbers in a given column into negative values
    By Mihir Manohar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2014, 04:25 PM
  3. Need help to convert numbers into preset values
    By christianlie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2010, 04:44 AM
  4. [SOLVED] how do I convert copied Text numbers into values in Excel?
    By R.VENKATARAMAN in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  5. how do I convert copied Text numbers into values in Excel?
    By R.VENKATARAMAN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. how do I convert copied Text numbers into values in Excel?
    By MOE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. how do I convert copied Text numbers into values in Excel?
    By MOE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Tags for this Thread

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