Results 1 to 7 of 7

Having problem to convert a range to a number format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Having problem to convert a range to a number format

    Hi. I'm trying to convert a range (a1:a12 in the sample) to a number format, but the code below does nothing.

    Know this tiny green sign appears on a cell when there is an error? It suggested me to convert the cell to a number, but when I tried to record this move in order to check its code, it produced basicallty an empty code.. weird, isn't it?

    Dim b As Range, c As Double
    Set b = Worksheets("dirot").Range("a40:a51")
    b.Select
    b.NumberFormat = "0"
    c = Application.Max(b)
    MsgBox c
    Attached Files Attached Files
    Last edited by GIS2013; 02-26-2014 at 08:40 AM. Reason: typo
    Please * if you like the answer

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  2. Excel: How to convert time format into number format that can be added?
    By Frances Jones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2012, 04:10 PM
  3. Convert [h]:mm sum total format to number format
    By Guy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. [SOLVED] convert text-format number to number in excel 2000%3f
    By Larry in forum Excel General
    Replies: 1
    Last Post: 07-29-2005, 04:05 PM
  5. Convert numbers from text format to number format
    By merlin68 in forum Excel General
    Replies: 4
    Last Post: 04-12-2005, 09:06 AM

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