It would be helpful is you post the code that is causing the problem.
The value 35449 looks suspiciously like a serial date.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 3 Dec 2008 12:25:50 -0800, Tina
wrote:

I have a range("e7").value in a function and it gets 1108, but then when it
goes to another function to get the same range - its does not, it got 35449
instead. Why is that? This used to work until I changed it from 1008 to
1108. This is set to text with the '1108 as such in the file.