Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Deleting zeros

  1. #1
    Guest

    Default

    Hello people
    I have a column contains some number which start with 0
    eg.
    0123
    022
    033
    123
    33
    How can I delete those zeros?
    Thanks in advance

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    You could use Edit>Replace but this would also delete zeros in any position. Use this function instead:

    =SUBSTITUTE(A1,"0","")*1

    It will result in a real number.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It appears that you have a column of text representations of numbers (e.g., "033"). If you wish to convert these to numeric values select 'em, choose the Data | Text to Columns... menu command and press [ Finish ].

  4. #4
    Guest

    Default

    That's so easy and quick
    Thanks alot Mark

Some videos you may like

User Tag List

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
  •