Performing Integer Divisions

If you need to do a lot of work with whole numbers (integers), then you may wonder which of three functions you should use to perform integer divisions. This function looks at the similarities and differences of the INT, TRUNC, and QUOTIENT functions.

Read this tip »

(Thanks to Ken Siskind, Michael Avidan (MVP), Steve Aprahamian, Ryszard Raciborski, Dave Newcomer, Brian Dorey, Bob Beechey, Murray Belchamber, Fred van der Meulen, Dave Shepherd, and Omar Cosme for contributing to this tip.)

Different CSV Formats

Excel provides different CSV formats you can use to export your workbook data for use with other programs. What are those formats, and how do they differ from each other?

Read this tip »

Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

Formatted Dates Appear Differently on Different Systems

When you format a date in a specific manner, you may be surprised to see that the format changes when you open the workbook on a different system. There is a reason for this change, as described in this tip.

Read this tip »

Using Seek In a Macro

When reading information from a text file, your macro may need to start reading at a place other than the beginning of the file. This is where the Seek function comes into play.

Read this tip »

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Converting Text Notation Values to Numeric Values

I receive my bank statement as a PDF file each month. When I convert it to an Excel file, the numbers end up in the format 5,000CR and 257DB. I need to convert these obviously text values into actual numbers, with the CR amounts being negative and the DB amounts being positive. Is there an easy way to do this?
—Aakhil Hoosain (provide an answer for this Help Wanted question)