LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default all General formats of the workbook changed to date format suddenl



hi,
i'm working with excel 2007, did not change any definition of the style, and
susddenly all the "General" formats of the workbook changed to date.
my range includes several types: Dates, numbers, general... only the general
formats changed into date. i can not change the whole range to general since
the real dates will be dispalyed not ok.
the file is very big, i can not change it cell by cell.
i'm looking for general solution.

do you have any idea how to avoid it. do you have any idea how to solve the
spoiled the file?
thanks,
Miri
 
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
all the general formats of the workbook suddenly changed to date. Miri Excel Discussion (Misc queries) 2 May 25th 08 12:23 PM
all the general formats suddenly replaced with date format. Miri Excel Discussion (Misc queries) 1 May 20th 08 12:47 PM
MS Excel 2007 file default general is changed to date, very annoying, please help? [email protected] Excel Worksheet Functions 0 March 21st 07 06:52 PM
I changed the "general" number format - I want it back Raymah Excel Discussion (Misc queries) 2 December 26th 06 04:33 PM
excel date formats changed bob Excel Worksheet Functions 1 March 1st 05 02:59 PM


All times are GMT +1. The time now is 12:09 PM.

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

About Us

"It's about Microsoft Excel"