• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    How to convert values to labels in a spreadsheet column?

    Tq both. Most helpful.
  2. M

    How to convert values to labels in a spreadsheet column?

    If i put in 5:12:07 excel recognises this as " 5:12:07 AM" If i put in 5:12:77 excel recognises this as 0.217558 ( fair enough as there are only 60 secs in a minute. Interesting to know how that entry is handled by excel). I can go with the mid function to convert 5:12:07 AM into 312.07...
  3. M

    How to convert values to labels in a spreadsheet column?

    Tq Narayank991, Grinding on ):
  4. M

    How to convert values to labels in a spreadsheet column?

    Tq Hui. What i am after is actually to try to introduce an apostrophe before the number in the cell. I can do it for one cell but when there is a stack of maybe fifty it gets tedious. Is there a formatting choice or a macro i can create?
  5. M

    How to convert values to labels in a spreadsheet column?

    Hi, a newbie. How do i do the above for a column containing say, ten values?
Back
Top