Open file and set numbers of decimal points
 

Hi,
I have a problem: if I open an xls file (2003) the numbers are, by
default, shown with 2 decimal point (eg: 189,47).
If I want to see then with only 1 decimal point (189,5) how can I do?
I can't use VBA :(

Thanks in advance

Cheers BlackSun

Open file and set numbers of decimal points
 

Perhaps i'm oversimplifying things but how about formatting the cell
to 2 decimals?
right clickformat cellsNumberNumberDecimal Places=1
?
Bear in mind that this would affect only the way you 'see' the value
while the value will still as it was.


On Mar 15, 9:24*am, BlackSun wrote:
Hi,
I have a problem: if I open an xls file (2003) the numbers are, by
default, shown with 2 decimal point (eg: 189,47).
If I want to see then with only 1 decimal point (189,5) how can I do?
I can't use VBA :(

Thanks in advance

Cheers BlackSun

Open file and set numbers of decimal points
 

Hi,
it's not what I need unfortunately... I need that this action must be
automatic when I open _every_ file in excel.

Thanks again

Cheers BlackSun

On 15 Mar, 10:35, AB wrote:
Perhaps i'm oversimplifying things but how about formatting the cell
to 2 decimals?
right clickformat cellsNumberNumberDecimal Places=1
?
Bear in mind that this would affect only the way you 'see' the value
while the value will still as it was.

Open file and set numbers of decimal points
 

On Mar 15, 6:48*am, BlackSun wrote:
Hi,
it's not what I need unfortunately... I need that this action must be
automatic when I open _every_ file in excel.

Thanks again

Cheers BlackSun

On 15 Mar, 10:35, AB wrote:



Perhaps i'm oversimplifying things but how about formatting the cell
to 2 decimals?
right clickformat cellsNumberNumberDecimal Places=1
?
Bear in mind that this would affect only the way you 'see' the value
while the value will still as it was.- Hide quoted text -

- Show quoted text -
The only thing I can recommend for all you won't like.
toolsoptionseditcheck fixed decimalsset to 1
Now when you enter 2 you will get .2, 22 - 2.2, 222=22.2, etc.

Open file and set numbers of decimal points
 

It is possible to create a macro, that you would only have to use one time.
It would open every workbook in every folder and change the "Normal" style for that workbook and
save the workbook.
Once that was done, only brand new workbooks would require a style change before saving.
(no, I am not offering to write it for you)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles: lists/removes unused styles & number formats - in the free folder)



"BlackSun"
wrote in message
...
Hi,
it's not what I need unfortunately... I need that this action must be
automatic when I open _every_ file in excel.

Thanks again

Cheers BlackSun

On 15 Mar, 10:35, AB wrote:
Perhaps i'm oversimplifying things but how about formatting the cell
to 2 decimals?
right clickformat cellsNumberNumberDecimal Places=1
?
Bear in mind that this would affect only the way you 'see' the value
while the value will still as it was.

Open file and set numbers of decimal points
 

If you want all NEW workbooks and worksheets to have format of 1 DP you can
alter the default workbook Excel uses as "New"

Open a new workbook and format all cells on all sheets to to 1 DP

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name
your workbook "BOOK"(no quotes). Excel will add the .XLT to save as
BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button
FileNew or CTRL + n

WARNING for Excel 2003................Do not use FileNew...Blank Workbook
or you will get the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx


Gord Dibben MS Excel MVP




On Tue, 15 Mar 2011 02:24:28 -0700 (PDT), BlackSun wrote:

Hi,
I have a problem: if I open an xls file (2003) the numbers are, by
default, shown with 2 decimal point (eg: 189,47).
If I want to see then with only 1 decimal point (189,5) how can I do?
I can't use VBA :(

Thanks in advance

Cheers BlackSun