+ Reply to Thread
Results 1 to 4 of 4

Number format (text with number in millions)

  1. 01-12-2023, 04:37 PM #1
    jw01
    jw01 is offline
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Number format (text with number in millions)

    Hi there

    Im having some logic issue

    trying to make the following statement:

    Revenue ($0.7M)

    im using this formula, but cant seem to get the logic correct, M33 contains the number

    Please Login or Register  to view this content.
    can someone assist with what im doing incorrect? thxs
    Last edited by jw01; 01-12-2023 at 05:40 PM.
    Reply With QuoteRegister To Reply
  2. 01-12-2023, 04:55 PM #2
    tanasedn
    tanasedn is offline
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Number format (text with number in millions)

    Trty this:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Diana Tanase

    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
    Reply With QuoteRegister To Reply
  3. 01-12-2023, 05:41 PM #3
    jw01
    jw01 is offline
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Number format (text with number in millions)

    great thanks.
    Reply With QuoteRegister To Reply
  4. 01-13-2023, 12:14 AM #4
    tanasedn
    tanasedn is offline
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Number format (text with number in millions)

    You are welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change a number into text with the use of currency number format
    By sunboy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-22-2021, 04:00 PM
  2. Correct text number to excel number format?
    By domgilberto in forum Excel General
    Replies: 9
    Last Post: 09-11-2015, 05:39 PM
  3. Need to Format Small Number of Cells From Text to Number
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-19-2014, 05:58 AM
  4. Excel 2007 : Number format for millions and billions
    By bruiser in forum Excel General
    Replies: 1
    Last Post: 06-14-2011, 02:49 AM
  5. [SOLVED] Change number format from text to number?
    By Scot in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-01-2005, 12:20 PM
  6. How to format number with mixed number and text?
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 10-22-2005, 02:05 PM
  7. [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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1