If you reference a cell that has a format (other then General), the
reference cell will adopt the same format.
--
Regards
Dave Hawley
www.ozgrid.com
"NGBalaji" wrote in message
...
I am using MS Excel 2007. Most of my excel files saved with default cell
format as General while creation; currently for the last two days when i
open
those files the cell content format is showing as currency format.
Pls let me how to fix the same