Quote Originally Posted by koolsid View Post
Basically I am storing 200908250700 as '200908250700 in the cell. The ' will store the number as string...
You really don't want to do that - Excel may not be be able to perform calculations.
We had this issue not long ago when someone did just that same mistake and it took some time to troubleshoot it.