Problem with Excel Formatting

[Sands89]

Good Afternoon Folks,

I have an excel sheet set up using excel 2003 that has cells in 1 shee
pulling info from another sheet within the same workbook. However whe
pulling the info accross, 1 of the cells is not displaying correctly.

The cell in question is displaying a date even though the info it
pulling accross is a percentage.
Despite changing the format of said cell to a percentage, for som
unknown reason it changes directly back to a date.

Can anyone shed some light as to why it would do this?

There are no conditional formats and no VBA code linked to these cells


Happy Problem Solvin

 

[Mazzaropi]

Good Afternoon Folks,
I have an excel sheet set up using excel 2003 that has cells in 1 shee
pulling info from another sheet within the same workbook. However whe
pulling the info accross, 1 of the cells is not displaying correctly.
The cell in question is displaying a date even though the info it
pulling accross is a percentage.
Despite changing the format of said cell to a percentage, for som
unknown reason it changes directly back to a date.
Can anyone shed some light as to why it would do this?
There are no conditional formats and no VBA code linked to these cells

Happy Problem Solving

Dear *Sands89*, Good Afternoon.

Any chance you could show us an example of the workbook to make i
easier to understand the issue?
Seeing the worksheet, the help will be quicker and more effetctive t
solve your question.
Please, attach it here