MrExcel Publishing
Your One Stop for Excel Tips & Solutions

reformatting large columns of cells

Posted by Barry P. on August 15, 2001 1:03 PM

I have column of 30,000+ cell values imported from a .dat file. I want to change the format to add dashes between certain characters, similar to SSN format. I've created the format and copied it onto the cells, but they don't change unless I select and individual cell, press F2, and press Enter. How can I activate the new format for all 30,000 cells without going through them one at a time?

Posted by Barrie Davidson on August 15, 2001 1:15 PM

Sounds like you need to calculate. Make sure you have calculation set to automatic (or press F9 to perform the calculation manually). If pressing F9 doesn't do the trick, try CTRL+ALT+F9 to force a re-calc. This is a known bug in Excel97.

Hope this helps you out.


Posted by Barrie Davidson on August 15, 2001 1:16 PM

PS - You're spelling your name wrong : )