+ Reply to Thread
Results 1 to 4 of 4

Amount appears as text instead of number in other cell

  1. #1
    Registered User
    Join Date
    06-23-2022
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    MS Office 365
    Posts
    2

    Amount appears as text instead of number in other cell

    Hello I am Henk from Amsterdam, NL and I am new to this forum, I hope you can help me with a Macro issue.

    For automatic generation of amount from one cell (at another worksheet) to another cell (for a Purchase Order), I use a macro. The only problem is, as soon as there are decimal places of the given amount, Excel automatically starts seeing it as text somehow.

    Schermafbeelding 2022-06-23 123418.jpg

    This can't be fixed with cell properties either, I've already tried that.



    In the code it is about the parts: 'priceExtransport' and 'transportCosts' which should be automatically entered in the worksheet 'Purchase Order' and then rolled out as text instead of amount...

    Please Login or Register  to view this content.
    Can you help me make it an automatic amount again, including decimal amounts?
    Last edited by henk_excel; 06-23-2022 at 09:28 AM. Reason: Solved

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Amount appears as text instead of number in other cell

    Anything that looks (to me) like a price is declared as String. So they go into the cell as text.
    Please Login or Register  to view this content.
    Declare these as Currency.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-23-2022
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    MS Office 365
    Posts
    2

    Re: Amount appears as text instead of number in other cell

    Thanks! It works

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Amount appears as text instead of number in other cell

    You're welcome and thanks for the rep!

+ 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. Replies: 3
    Last Post: 07-27-2021, 10:41 AM
  2. Count amount of times "A/L" text appears in a row
    By King Mustard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2021, 11:16 PM
  3. [SOLVED] VBA Cell change after text/number appears
    By Workforfun in forum Excel General
    Replies: 4
    Last Post: 09-26-2019, 05:26 AM
  4. Replies: 9
    Last Post: 10-16-2015, 12:42 PM
  5. Replies: 4
    Last Post: 12-10-2014, 08:47 PM
  6. Replies: 2
    Last Post: 05-09-2013, 06:17 AM
  7. Count amount text appears with extra criteria
    By tinybear77 in forum Excel General
    Replies: 5
    Last Post: 02-10-2011, 07:54 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