+ Reply to Thread
Results 1 to 5 of 5

Custom format to text same as custom format

  1. #1
    Registered User
    Join Date
    12-29-2013
    Location
    turkey
    MS-Off Ver
    Excel 2010
    Posts
    2

    Custom format to text same as custom format

    Dear friends,

    I have a problem about custom format. i have a cell contains "1" and with custom format becomes "00 01" with ###00 00.

    I would like to have a cell with text "00 01" not "1".

    did i express my self?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Custom format to text same as custom format

    You have it looking like "00 01" and you want it to look like "00 01" - I don't understand....
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-29-2013
    Location
    turkey
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Custom format to text same as custom format

    in thi sexample cell content is "1". excel shows "00 01" in the screen. what i want, i want the content of cell become "00 01" when cell format text.

    TEST.jpg
    i will try to explain again, i have a cell which is includes number 1. with cell format i can see it "00 01". i try to copy this number to another cell wich cell format is text. at that cell i need to have 00 01 inside..
    this may be done with vba i dont know

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Custom format to text same as custom format


  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Custom format to text same as custom format

    In E4 enter 1
    In F4 enter formula

    =TEXT(E2,"00 00")
    F4 displays 00 01 as text
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. Help with custom text format
    By stephme55 in forum Excel General
    Replies: 3
    Last Post: 06-23-2016, 03:34 PM
  2. custom format with text and numbers
    By source in forum Excel General
    Replies: 5
    Last Post: 10-31-2014, 02:54 PM
  3. Changing from custom value to text format
    By luke.guthrie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2012, 11:00 AM
  4. Change format from custom to text
    By luke.guthrie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2012, 03:34 PM
  5. Custom format with text
    By PierreL in forum Excel General
    Replies: 2
    Last Post: 10-14-2005, 02:05 PM
  6. [SOLVED] Custom format text
    By coco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2005, 01:05 PM
  7. [SOLVED] How to format text and numbers as custom
    By Julian Ganoudis in forum Excel General
    Replies: 4
    Last Post: 04-04-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1