M
Marta
I have created a custom cell format but it doesn't seem to get saved when I exit the worksheet. What am I doing wrong?
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.
D
Dave Peterson
Does this mean when you reopen the workbook, that custom cell format isn't
there?
(If yes, did you remember to save your workbook when closing?)
or does this mean that the custom format isn't available in a different
workbook.
If yes to this, just copy that cell, the paste special|formats into the workbook
you want. Then you'll have it and can use it for other cells.
After you use it for real, you can clean up that cell you pasted into.
there?
(If yes, did you remember to save your workbook when closing?)
or does this mean that the custom format isn't available in a different
workbook.
If yes to this, just copy that cell, the paste special|formats into the workbook
you want. Then you'll have it and can use it for other cells.
After you use it for real, you can clean up that cell you pasted into.
D
Dave Peterson
Maybe you could add a macro to your personal.xls that changes the formatting:
Option Explicit
Sub ChangeFormats()
Selection.NumberFormat = "###-#####-##-###"
'or maybe:
'Selection.NumberFormat = "000-00000-00-000"
End Sub
(Did you really want #'s?)
You could assign it a nice shortcut (ctrl-q???) and then select the range to get
the customformat and hit the shortcut button (or alt-f8 and run it. Or
tools|macro|macros and run it.)
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
===
Personal.xls is a workbook that's stored in your XLStart folder. Each time you
open excel, excel will open this workbook. And you'll have your macro
available.
To create/change the shortcut key:
Tools|macro|macros
select your macro
click on Options
type in your letter (I'd stay away from C/X/V (copy/cut/paste) and other
existing shortcut keys)
and ok your way out and cancel at that last dialog.
Option Explicit
Sub ChangeFormats()
Selection.NumberFormat = "###-#####-##-###"
'or maybe:
'Selection.NumberFormat = "000-00000-00-000"
End Sub
(Did you really want #'s?)
You could assign it a nice shortcut (ctrl-q???) and then select the range to get
the customformat and hit the shortcut button (or alt-f8 and run it. Or
tools|macro|macros and run it.)
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
===
Personal.xls is a workbook that's stored in your XLStart folder. Each time you
open excel, excel will open this workbook. And you'll have your macro
available.
To create/change the shortcut key:
Tools|macro|macros
select your macro
click on Options
type in your letter (I'd stay away from C/X/V (copy/cut/paste) and other
existing shortcut keys)
and ok your way out and cancel at that last dialog.