TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive
SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements
CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters.
Database Converters, Spreadsheet Converters, Text Converters, E-mail
Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $
IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $
CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3
CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.
To hide zeros cell-by-cell use a Custom Number Format like
0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.
To hide zeros on the Workbook level go to
Tools>Options>View - Zero Values.
×