Results 1 to 3 of 3

Thread: Formatting a number
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formatting a number

    Good morning everyone,
    I have many numbers in excel which read like this; @01392293
    I need the numbers to read like this; '@01392293',

    When I try to format the number to custom it reads the ' at the beginning but not the rest. I'm not sure how to do this?
    Any help is appreciated.

    Thanks

  2. #2
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Boston, Massachusetts
    Posts
    2,287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formatting a number

    Assuming the actual text value is: '@1392293

    You could try this custom number format which applies your desired format to the cell value if it is text:
    Code:
    0;0;0;'@'
    With that format, the above text displays as this: '@1392293'

    Is that something you can work with?
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (2006 - 2015)
    Using: Excel 2013 & 2016

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: Formatting a number

    Quote Originally Posted by Ron Coderre View Post
    Assuming the actual text value is: '@1392293

    You could try this custom number format which applies your desired format to the cell value if it is text:
    Code:
    0;0;0;'@'
    With that format, the above text displays as this: '@1392293'

    Is that something you can work with?

    My number was actually @01392293 and I wanted it to be '@01392293',
    I used your custom format 0;0;0;'@', to get what I wanted and it worked!

    Thanks Ron! and thank you for your quick response. Have a great day

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •