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

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

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

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

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

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

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

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

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