• 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 sepate numbers and text

    Ashokraju Luke M I’m not sure that my contribution falls into the category of “some pretty fancy VB” but it does work :-) I have uploaded a file to https://dl.dropbox.com/u/95000482/Retain_Text_Formats_1a.xls The file contains 2 sheets, one containing only 5 records (based on the original...
  2. M

    How to convert from NUMBER format to TEXT format to accept another software

    Nazmul As they say, don't knock it until you try it. My method sounds long winded, but only involves clicks of your left mouse button - typically 7 or 8 - and takes less than 10 seconds from start to finish. No typing of formulas, no finding macros in lists. On a column of 65536 records, Hui's...
  3. M

    How to convert from NUMBER format to TEXT format to accept another software

    @nazmul_muneer You can convert from NUMBER to TEXT in the same column if you want to. It is a great way of removing numbers that come in to a spreadsheet in scientific notation as well, to avoid such lovely entries as 1E+06 etc. Highlight the column [will also work on part of a column if you...
Back
Top