Question Locked

I'm using Excel 2007 I need to keep formatting to text

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I know about protecting the worksheet which would work if I didn't need to use the text to column feature. Excel changes 12-** to general formatting giving me a number I don't want. Does anyone have any suggestions?

2 replies

by seanferd

Apply whichever formatting style you want to all cells requiring the formatting. If done by row or column, the formatting should follow along as new columns/rows are appended to the existing sheet.

This discussion is closed to new replies.