Results 1 to 2 of 2

Thread: Converting text strings to points

  1. 10-23-2011, 06:20 PM #1
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Converting text strings to points

    Can anybody tell me - How to convert the length of a text string into points. I am using a multi column Listbox
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
  2. 10-23-2011, 08:23 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    I think you should go with Truetype font like Courier which has fixed length for all characters.

    See: Description of how column widths are determined in Excel
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Did You Know :: Bullet Points & Line Breaks in Excel Cells
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 06-11-2013, 01:55 PM
  2. Converting Excel Sheets automatically into Powerpoint Slides
    By Howardc in forum Powerpoint Help
    Replies: 2
    Last Post: 04-14-2013, 08:23 PM
  3. Converting a Column Number to a Column Letter
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 12-17-2012, 02:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules