Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Count formula doesn't work

  1. #11
    Guest

    Default

    Mr. Hawly
    How do you format a column as any number format?

    I also try the other way. However, because my column has many blank cells
    e.g
    Mill
    ----
    55




    Mill
    ----
    55
    So after edit special mutiply, my column becomes

    Mill
    ----
    55
    0
    0
    0
    0
    0
    Mill
    ----
    55
    So is there a way to select the text/number but not the blank cells?

  2. #12
    Guest

    Default

    Hey guys I got it
    I select the whole column and go to Edit->Go to->special->constant and it select all the data(with no blank cells)
    Thank you guys for showing me how to change "text" number to "real number"
    very appreciated

  3. #13
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just checking my password is all

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
  •