How to let excel don't change user's format?

I have an cell set the format as General, and then have formula to reference cell. Once retrieve the data (Hyperion Smartview), the cell format become Text (e.g. instead of data in the cell reference, it shows as "=D2")