Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
Fill/Extend Series adding decimal points to some numbers | Excel Worksheet Functions | |||
sorting numbers with decimal points | Excel Worksheet Functions | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) |