The article on Microsoft.com "How to convert a numeric value into English words in Excel" provides some VBA code for converting a dollar value into words, like you would see on checks or receipts.
Showing posts with label Formatting. Show all posts
Showing posts with label Formatting. Show all posts
Display Feet and Inches as 5' 8 1/2"
When converting metric distances to English units of feet or inches, you'll end up with a decimal value. But, you may want to display the value as feet and inches using the format 5' 8 1/2".
Labels:
Formatting
Highlighting Every Other Row Using Conditional Formatting
Conditional Formatting (accessed via the Format menu) often makes spreadsheets seem to behave like 'magic' because when a user copies cells, the formatting can change automatically without the user knowing why.
Labels:
Formatting
Subscribe to:
Posts (Atom)