F
Fog
Wish to have a two decimal number displayed instead of variable under general
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike Rogers
Fog
Tools>options>edit tab & check "Fixed decimal Places, then set them to 2 in
the drop down.
Mike Rogers
Tools>options>edit tab & check "Fixed decimal Places, then set them to 2 in
the drop down.
Mike Rogers
T
Tyro
As I understand that, the setting will affect all workbooks.
Tyro
Tyro
D
Dave Peterson
You can create a new workbook with all the settings you like...including
changing the normal style for numbers.
in xl2003, format|style...
Select Normal
Click modify and change what you want on the number tab.
Name this new workbook book.xlt and store it in your XLStart folder, then excel
will use this template file whenever you click on the new icon on the standard
toolbar.
But I bet after you do this, you won't want to use it. Dates and times are
numbers to excel. By changing the default number format, you'll be changing the
number format each time you enter a date or time.
(You can also create a file named sheet.xlt that will be used as a template
whenever you insert a new worksheet into an existing workbook.)
changing the normal style for numbers.
in xl2003, format|style...
Select Normal
Click modify and change what you want on the number tab.
Name this new workbook book.xlt and store it in your XLStart folder, then excel
will use this template file whenever you click on the new icon on the standard
toolbar.
But I bet after you do this, you won't want to use it. Dates and times are
numbers to excel. By changing the default number format, you'll be changing the
number format each time you enter a date or time.
(You can also create a file named sheet.xlt that will be used as a template
whenever you insert a new worksheet into an existing workbook.)
S
Sandy Mann
Mike,
I my version of XL that only changes integers into two decimal numbers.
Floating point numbers stay as entered.
--
Reagrds,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
I my version of XL that only changes integers into two decimal numbers.
Floating point numbers stay as entered.
--
Reagrds,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
M
Mike Rogers
Sandy Mann
I do believe you are right. I think Dave is headed in the direction the op
wants but I think the "down side" of what they want is important to
understand. As in alot of things, it is not the solution, but the down side
that can come back and haunt you.
Mike Rogers
I do believe you are right. I think Dave is headed in the direction the op
wants but I think the "down side" of what they want is important to
understand. As in alot of things, it is not the solution, but the down side
that can come back and haunt you.
Mike Rogers