Count formula doesn't work - Page 2
Eliminate Pivot Table Annoyances
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

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
  •  

 

 
DMCA.com