Quick cell formatting (avoiding F2)

**doowop5000** · 09-27-2007, 07:07 AM

I've changed a number format to date and currently have to hit F2+enter to make cells change to the new format - is there any way to expedite this process / do it in mass??

Many thanks for any help!

**NBVC** · 09-27-2007, 07:51 AM

Preformat the cells....

**doowop5000** · 09-27-2007, 07:58 AM

...is there any other way? As this is exported from Crystal or other databases...

**NBVC** · 09-27-2007, 08:04 AM

How about selecting the columns/rows that contain these values and formatting them all at once?

**doowop5000** · 09-27-2007, 08:19 AM

Have done this (format cell> number > date) with all the cell highlighted, but you still have to F2 down. Have also tried highlighting all the cells after this, then hitting F2, but that only goes down cell by cell still.

I know there is a shortcut for this, but just can't remember!

**NBVC** · 09-27-2007, 08:35 AM

How about Data|Text to Columns.

Select one column at a time and go to Data|Text to columns...

skip to the 3rd screen and select Date from the Column Data Format area and select the correct configuration in the drop down next to the Date radio button.

Click Finish.