Excel Tips


Parsing with Characters »

November 15, 2001

When you are typing custom number formats, you can insert any single text character by preceeding it with a backslash.


Excel Crash on Mouse-Over of Object »

November 14, 2001

I have a document that has become very unstable. Every time that my mouse gets near one of the red comment triangles, Excel will crash.


Convert Multiline Data To Rows »

November 13, 2001

How to convert multiline data to rows.


Celect Random Numbers from a Column »

November 12, 2001

Select 5 random numbers from a column of 50 numbers.


Removing a Set Number of Characters From a Cell »

November 11, 2001

What I need to do throughout a big worksheet was to edit the cell, move the cursor to the end of the cell and then delete the last 4 characters if the characters.


Creating Page Breaks in Excel Automaticaly »

November 10, 2001

Trying to automatically put page breaks into a table in Excel.


Create a Unique Record Number »

November 9, 2001

We need to know how to set up a macro which will assign a unique invoice number.


Changing Numbers to Text »

November 8, 2001

Looking for a way to change text that looks like numbers to real text.


Parsing Date String »

November 7, 2001

I have the date 19960105 for example, but excel doesn't recognize it as a date without me having to put two slashes into it.