| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Cell Format
I am using Excel 2003 and trying to customize the cells with leading zeros.
It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
what does the custom format show before you save it and after you save it?
"Richardb" wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
The custom format shows: 000000 (six zeros). After I close Excell and open
it again it disappears. "bj" wrote: what does the custom format show before you save it and after you save it? "Richardb" wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
Works for me depending upon the numbers entered.
What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
It works ok when changing on existing sheet but will not save when saving as
template in the startup. I am using 6 zeros. "Gord Dibben" wrote: Works for me depending upon the numbers entered. What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
How are you opening the New workbook?
FileNew...Blank workbook will give you the Excel default workbook with no formatting. Hit the FileNew(no ellipsis) to open a new workbook based on your BOOK.xlt in XLSTART folder Or hit the New Icon on the Toolbar. I just cannot replicate your problem. Gord On Fri, 25 May 2007 13:40:02 -0700, Richardb wrote: It works ok when changing on existing sheet but will not save when saving as template in the startup. I am using 6 zeros. "Gord Dibben" wrote: Works for me depending upon the numbers entered. What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
I also use 2003
when I save a template witrh custom formatting it is there when I open it. Have you reinstalled Excel? I can't duplicate your problem "Richardb" wrote: The custom format shows: 000000 (six zeros). After I close Excell and open it again it disappears. "bj" wrote: what does the custom format show before you save it and after you save it? "Richardb" wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
Still does not work. If I go to C:\Documents and Settings\Cosmo\Application
Data\Microsoft\Templates and click on the Book it works. "Gord Dibben" wrote: How are you opening the New workbook? FileNew...Blank workbook will give you the Excel default workbook with no formatting. Hit the FileNew(no ellipsis) to open a new workbook based on your BOOK.xlt in XLSTART folder Or hit the New Icon on the Toolbar. I just cannot replicate your problem. Gord On Fri, 25 May 2007 13:40:02 -0700, Richardb wrote: It works ok when changing on existing sheet but will not save when saving as template in the startup. I am using 6 zeros. "Gord Dibben" wrote: Works for me depending upon the numbers entered. What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
Maybe you have BOOK.xlt in the wrong XLSTART folder.
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 25 May 2007 14:30:01 -0700, Richardb wrote: Still does not work. If I go to C:\Documents and Settings\Cosmo\Application Data\Microsoft\Templates and click on the Book it works. "Gord Dibben" wrote: How are you opening the New workbook? FileNew...Blank workbook will give you the Excel default workbook with no formatting. Hit the FileNew(no ellipsis) to open a new workbook based on your BOOK.xlt in XLSTART folder Or hit the New Icon on the Toolbar. I just cannot replicate your problem. Gord On Fri, 25 May 2007 13:40:02 -0700, Richardb wrote: It works ok when changing on existing sheet but will not save when saving as template in the startup. I am using 6 zeros. "Gord Dibben" wrote: Works for me depending upon the numbers entered. What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
Do not think so. I have no other xlt files anywhere else
"Gord Dibben" wrote: Maybe you have BOOK.xlt in the wrong XLSTART folder. C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 25 May 2007 14:30:01 -0700, Richardb wrote: Still does not work. If I go to C:\Documents and Settings\Cosmo\Application Data\Microsoft\Templates and click on the Book it works. "Gord Dibben" wrote: How are you opening the New workbook? FileNew...Blank workbook will give you the Excel default workbook with no formatting. Hit the FileNew(no ellipsis) to open a new workbook based on your BOOK.xlt in XLSTART folder Or hit the New Icon on the Toolbar. I just cannot replicate your problem. Gord On Fri, 25 May 2007 13:40:02 -0700, Richardb wrote: It works ok when changing on existing sheet but will not save when saving as template in the startup. I am using 6 zeros. "Gord Dibben" wrote: Works for me depending upon the numbers entered. What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Cell Format
The path I posted is the correct path to store BOOK.xlt
Sorry for any misunderstanding on that. No more suggestions from this end. Gord On Fri, 25 May 2007 16:31:00 -0700, Richardb wrote: Do not think so. I have no other xlt files anywhere else "Gord Dibben" wrote: Maybe you have BOOK.xlt in the wrong XLSTART folder. C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 25 May 2007 14:30:01 -0700, Richardb wrote: Still does not work. If I go to C:\Documents and Settings\Cosmo\Application Data\Microsoft\Templates and click on the Book it works. "Gord Dibben" wrote: How are you opening the New workbook? FileNew...Blank workbook will give you the Excel default workbook with no formatting. Hit the FileNew(no ellipsis) to open a new workbook based on your BOOK.xlt in XLSTART folder Or hit the New Icon on the Toolbar. I just cannot replicate your problem. Gord On Fri, 25 May 2007 13:40:02 -0700, Richardb wrote: It works ok when changing on existing sheet but will not save when saving as template in the startup. I am using 6 zeros. "Gord Dibben" wrote: Works for me depending upon the numbers entered. What does your custom formatting look like? 0 will return 01 if one digit entered. 00 will return 011 if two digits entered or 001 if one digit entered. Do you want a single preceding 0 no matter the length of the numeric entered? I'm not aware of any way to do that with custom formatting but hang in.........someone may know how. Where are you saving the templates? If you store them in your XLSTART folder as BOOK.xlt and SHEET.xlt they will be the default New workbook and InsertSheet Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:46:02 -0700, Richardb wrote: I am using Excel 2003 and trying to customize the cells with leading zeros. It works in the current workbook but when I try to save the woorkbook as an xlt file it disappears. I have tried to save as Book.xlt, Book1.xlt and Sheet.xlt. Any help would be greatly appreciated. Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Cell Format, Zero Pad | Excel Discussion (Misc queries) | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Custom Cell Format | Excel Discussion (Misc queries) | |||
| Custom Cell Format | Excel Worksheet Functions | |||
Linear Mode
