| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default cell format has reverted to Time
I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default
cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
Hallo Tony,
on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
Joachim:
Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
Hallo Tony,
I am using Excel 2007 SP2. In my version the group with the format templates is under the Home tab just left of the group Cells. -- Regards Joachim "Tony Rice" wrote: Joachim: Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
Hallo Tony,
my apologies. The group is Styles and the first click is Format Styles. The rest should be as in my first message. -- Regards Joachim "Tony Rice" wrote: Joachim: Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
Joachim:
Many thanks again, but I am really puzzled: I downloaded SP2 and it told me that it was already installed. I still cannot see "Format Template" anywhere on my ribbon, so I went Office Button|Excel Options|Customize|All Commands I cannot see "Format Template" There is nothing in Help about "Format Template" either Do you have "Format Template" in your All Commands? -- yours in frustration Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, I am using Excel 2007 SP2. In my version the group with the format templates is under the Home tab just left of the group Cells. -- Regards Joachim "Tony Rice" wrote: Joachim: Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
Sorry Joachim
I cannot find "Format Styles" in All Commands either -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, my apologies. The group is Styles and the first click is Format Styles. The rest should be as in my first message. -- Regards Joachim "Tony Rice" wrote: Joachim: Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default cell format has reverted to Time
After further searching on the Web, I found the answer, which is:
Home|Styles|Cell Styles right click on "Normal" Modify|Format|Number|General|OK|OK Thanks for trying -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, my apologies. The group is Styles and the first click is Format Styles. The rest should be as in my first message. -- Regards Joachim "Tony Rice" wrote: Joachim: Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tony you Rock
Dear Tony,
Thank you so very much for returning to this post and posting the solution you eventually found. It helped me immensely with a similar problem I experienced with Excel 2007, when somehow my default cell format magically changed to Date on one of my very valuable, large-amount-of-time-invested spreadsheets. I too was completely puzzled by Joachim's advice and could not make any sense of it. I never would have thought to right click on Normal in the styles setting for this. You're my hero. thanks, ted... Tony Rice wrote: After further searching on the Web, I found the answer, which 25-Sep-09 After further searching on the Web, I found the answer, which is: Home|Styles|Cell Styles right click on "Normal" Modify|Format|Number|General|OK|OK Thanks for trying -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Previous Posts In This Thread: On Friday, September 25, 2009 6:14 AM Tony Rice wrote: Default cell format has reverted to Time I have a 2007 macro enabled workbook with 90 sheets. Suddenly the default cell format has reverted to Time instead of General. When I insert a new sheet, every cell is formatted to Time. Apart from re-bulding the entire workbook, how can I correct this? -- Founder of Production-Scheduling.com On Friday, September 25, 2009 6:55 AM Joachim wrote: Hallo Tony,on Home tab select cell format templates, right click General, Hallo Tony, on Home tab select cell format templates, right click General, click change, select number format, click format, select general, click OK, make sure the number format check box is checked and OK. -- Regards Joachim "Tony Rice" wrote: On Friday, September 25, 2009 7:20 AM Tony Rice wrote: Default cell format has reverted to Time Joachim: Thank you for responding, but I cannot find the menu you refer to. Under the Home tab I have Cells Under Cells I have Format Under Format I cannot see Templates I would appreciate your help -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: On Friday, September 25, 2009 7:49 AM Joachim wrote: Hallo Tony,I am using Excel 2007 SP2. Hallo Tony, I am using Excel 2007 SP2. In my version the group with the format templates is under the Home tab just left of the group Cells. -- Regards Joachim "Tony Rice" wrote: On Friday, September 25, 2009 8:23 AM Joachim wrote: Hallo Tony,my apologies. Hallo Tony, my apologies. The group is Styles and the first click is Format Styles. The rest should be as in my first message. -- Regards Joachim "Tony Rice" wrote: On Friday, September 25, 2009 8:44 AM Tony Rice wrote: Default cell format has reverted to Time Joachim: Many thanks again, but I am really puzzled: I downloaded SP2 and it told me that it was already installed. I still cannot see "Format Template" anywhere on my ribbon, so I went Office Button|Excel Options|Customize|All Commands I cannot see "Format Template" There is nothing in Help about "Format Template" either Do you have "Format Template" in your All Commands? -- yours in frustration Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: On Friday, September 25, 2009 8:50 AM Tony Rice wrote: Sorry JoachimI cannot find "Format Styles" in All Commands either-- Sorry Joachim I cannot find "Format Styles" in All Commands either -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: On Friday, September 25, 2009 9:41 AM Tony Rice wrote: After further searching on the Web, I found the answer, which After further searching on the Web, I found the answer, which is: Home|Styles|Cell Styles right click on "Normal" Modify|Format|Number|General|OK|OK Thanks for trying -- regards Tony Rice Founder of Production-Scheduling.com "Joachim" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice Make Your ASP.NET Mobile Forms Timer - Refresh http://www.eggheadcafe.com/tutorials...et-mobile.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time format shows default of 12:00 AM | Excel Worksheet Functions | |||
| how to change the default cell format | Excel Discussion (Misc queries) | |||
| i want default as Zero in date format cell | Excel Discussion (Misc queries) | |||
| How do I change the default cell format? | Excel Discussion (Misc queries) | |||
| Default cell format | Excel Discussion (Misc queries) | |||
Linear Mode
