Hi there,

I have a cell with date format YYYMMDD which gives result as 20100708. Problem is I want the same in text format, which give me only numbers in the cell as 20100708. I tried converting it into text but it gives result as 40367.

Is there any way to have it only as values.

thanks
Chet