Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Default Cell format of existing Worksheets got changed automatical

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 464
Default Default Cell format of existing Worksheets got changed automatical

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default format changed in Excel 2007 KLHills Setting up and Configuration of Excel 0 May 4th 10 06:16 PM
Why my default number format changed Edward Wang Excel Discussion (Misc queries) 0 April 11th 10 02:34 AM
Default Cell Format Changed? B Smith Excel Discussion (Misc queries) 5 November 21st 08 03:52 PM
Format changed when the details in cell changed angel Excel Worksheet Functions 9 July 15th 08 12:36 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM


All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"