Default formatting

Topic

New Reply

Some time back I thought that it would be convenient to have 1,234.00 as the default format. Now I find it aggravating, and I cannot recall how I set it. Help please.

Reply | Quote

Replies

Select Format | Style…
Select Normal in the list of styles.
Click Modify…
Set the number format to General.
OK your way out.

Reply | Quote

Select Format | Style…
Select Normal in the list of styles.
Click Modify…
Set the number format to General.
OK your way out.

This seems to affect only the selected cells. Any idea on where I have gone wrong?

Reply | Quote

Have the other cells been formatted with the Normal style?

Reply | Quote

Have the other cells been formatted with the Normal style?

I don’t see a display for the style; however when I pull down Format | Style I am presented with

Reply | Quote

As your screenshot shows, those cells have been formatted with the Comma style. You will have to format the cells with the Normal style, which you can select from the Style name dropdown.

Reply | Quote

As your screenshot shows, those cells have been formatted with the Comma style. You will have to format the cells with the Normal style, which you can select from the Style name dropdown.

Hans
I am attempting to set Normal as the Excel Default. The approach we have been taking seems to be specific to the selected sheets/cells; and does not stick with a new instance of Excel.

Reply | Quote

There is no application-wide default setting for number format.

Have you created a default template Book.xlt in Excel’s startup folder? If so, all blank new workbooks will use the settings from Book.xlt, including the style definitions.

Or you might have installed an add-in that tampers with the number format.

You might take a look at Jan Karel Pieterse’s [post=”290455″]Systematic Approach to behavioral Problems in XL[/post].

Reply | Quote

Have you created a default template Book.xlt in Excel’s startup folder?

Bingo !

Thank you for your patience Hans.

Reply | Quote