+ Reply to Thread
Results 1 to 3 of 3

Want number/accounting value from one cell to another in text format with other text

  1. #1
    Registered User
    Join Date
    03-06-2009
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    51

    Want number/accounting value from one cell to another in text format with other text

    Hello,

    In B2 cell I have 149,521. This value is in number/accounting format.
    In C2 cell I have given formula, ="we shipped "&B2&" CBM."
    C2 returns result= we shipped 149521 CBM.

    But I want the result like: we shipped 149,521 CBM.
    That is including the comma.

    How can I get my expected result? Attached is for you to get my question.

    Thanks
    Sharif
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Want number/accounting value from one cell to another in text format with other text

    Hi mshtuhin,

    You need to learn =Text(Number, Format).
    see attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-06-2009
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Want number/accounting value from one cell to another in text format with other text

    Wow, it is working perfectly. I am far far away to learn excel functions. But no worry as long as I am here with this forum and Guru's like you are here to assist.

    Many many many thanks to you sir

    brgds
    Tuhin

+ 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