I fixed the problem, but don't understand why or how.
I formated all the cells the same. Then I had to open each cell, as to edit the cell. All formulas are functioning properly. I'm glad I had only 500 cells to do that to. There has got to be a better way. If you know, please reply.
Thanks
I need to convert an .mdi file to excel. I first copied the information to a text file, then to excel. Doing this exercise allowed me to maintain the columns needed for a spreadsheet. I am using excel as a database, somewhat.
I put the converted information in a sheet. In another sheet I am...