Results 1 to 6 of 6

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

Threaded View

  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 :

        
       
        Range("A2:F2").Select
        Range(Selection, Selection.End(xlDown)).Select
        NumberFormat = "0.00"
        Selection.Style = "Currency"

    Thank You!

    Regards
    Wither
    Attached Files Attached Files

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. 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. [SOLVED] 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. [SOLVED] 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. [SOLVED] 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