+ Reply to Thread
Results 1 to 3 of 3

numbers with `comma style` in text format

  1. #1
    Registered User
    Join Date
    07-01-2012
    Location
    Tilburg, the Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    96

    numbers with `comma style` in text format

    Hi all,

    I`ve got a database, in which few columns are filled by the numbers in general, accounting or custom format, but for all of them `comma style` has been applied. So they look like this:

    32.200,00
    119.850,00
    38.608,00
    11.970,00
    11.970,00

    thousand separator and two numbers of digits. I need to have these numbers that look exactly like this, but with a text format (I`m exporting the data to Word file, that`s why). Is it possible to do that?
    So the goal is to obtain numbers that looks exactly like those above, but in text format (so no comma style is possible to be applied).
    And I need to do that by using macro.

    My colleague did it by pasting these columns to Notepad and then pasting it again to Excel, but I think it is not necessary


    Thanks in advance for your help!
    Karol

  2. #2
    Registered User
    Join Date
    07-01-2012
    Location
    Tilburg, the Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: numbers with `comma style` in text format

    by the way - I was trying to solve this problem by applying the code that has been proposed in this topic:

    http://www.excelforum.com/excel-prog...html?p=2972489

    but without results. Take a look at this, it might give you some idea how to deal with that

  3. #3
    Registered User
    Join Date
    07-01-2012
    Location
    Tilburg, the Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: numbers with `comma style` in text format

    now I was trying to do it in a following way:

    Please Login or Register  to view this content.
    but...
    while writing this code I received the following error:
    compile error
    expected end of statement


    and the following line has been highlighted:
    Please Login or Register  to view this content.
    to be precise, # has been highlighted

    what did I do wrong?
    Last edited by Vogelmann; 10-22-2012 at 11:39 AM.

+ 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