+ Reply to Thread
Results 1 to 2 of 2

Numbers to text

  1. 03-03-2017, 04:46 PM #1
    Patcheen
    Patcheen is offline
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Numbers to text

    how do i convert numbers to text
    cell A1 1000 result c1 should be one thousand

    i cant get it to work

    thank you
    Reply With QuoteRegister To Reply
  2. 03-03-2017, 04:58 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Numbers to text

    See: https://support.microsoft.com/en-gb/...words-in-excel
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    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. Copying numbers from HTML table into Excel: How to make them numbers, not text?
    By portsample in forum Excel General
    Replies: 4
    Last Post: 10-11-2016, 01:51 PM
  2. [SOLVED] make Userform entries with just numbers stay as text and not numbers upon pasting
    By vpan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2016, 02:13 PM
  3. Any way to import large text file of numbers without Excel splitting numbers?
    By makisupa94 in forum Excel General
    Replies: 19
    Last Post: 07-20-2014, 04:55 PM
  4. [SOLVED] Marco to convert numbers stored as text to numbers and dates stored as text to numbers
    By a2424 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2014, 10:19 AM
  5. [SOLVED] [SOLVED] Macro/Wildcard to remove only numbers excluding text with numbers
    By indianhp in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 08:16 AM
  6. [SOLVED] Convert all numbers stored as text or custom formatted to numbers &no decimals - 40 sheets
    By synses in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 01:46 AM
  7. Conditional Formatting for Numbers but text, dates, and blanks are treated as numbers??
    By evisu18 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-26-2012, 02:16 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