How to Convert Numbers to Text in Excel. Use list slicing and strupper to capitalize the first letter of the string. Create A Button In Excel To Capitalize Only The First Letter Of A Sentence Microsoft Excel Excel Tutorials Lettering Change Negative Number to Positive in Excel. . Make it tour habit never to use capital letters when writing code. If you narrow the width of a column displaying a number too much you will see a series of pound signs displayed in the cell. Corporate Finance Institute. To change a columns width in the gray bar at the top of the spreadsheet where the letters of the columns are displayed move your mouse cursor to the border between any two columns. Excel Custom Number Formatting. Thats a bit cumbersome though and prone to copy-paste errors for large sets of data. Without the use of the VBA code you cannot capitalize on a selected range of cells at once. PROPER function is categori