Date Format

[payton50325]

I have a check ledger program that the data in the cell can be either a
date or a check number. When I enter the date, I would like for it to
come up as 4/26 and not 26-Apr. Is there a way to make Excel use a
different format than the 26-Apr format? The cells are defaulted to
General. I am using a macro to change the date format in the cell where
this happens now. This is on Excel '04 using Mac 10.3.9 on a G4
powerbook.

 

[CyberTaz]

Hello Payton-

If you format the cells a TEXT they should work the way you describe. Just
keep in mind that you will not be able to involve those cells in
calculations (subtract one chk # form another to find out how many chks in
between, etc.) without using conversions.

HTH |:>)

I have a check ledger program that the data in the cell can be either a
date or a check number. When I enter the date, I would like for it to
come up as 4/26 and not 26-Apr. Is there a way to make Excel use a
different format than the 26-Apr format? The cells are defaulted to
General. I am using a macro to change the date format in the cell where
this happens now. This is on Excel '04 using Mac 10.3.9 on a G4
powerbook.

-- (e-mail address removed)

 

[JE McGimpsey]

I have a check ledger program that the data in the cell can be either a
date or a check number. When I enter the date, I would like for it to
come up as 4/26 and not 26-Apr. Is there a way to make Excel use a
different format than the 26-Apr format? The cells are defaulted to
General. I am using a macro to change the date format in the cell where
this happens now. This is on Excel '04 using Mac 10.3.9 on a G4
powerbook.

If the cell could be either a General format for check number or a date,
try (assuming your check numbers are <30000):

Format/Cells/Number/Custom [<30000]General;m/dd

 

[payton50325]

I have a check ledger program that the data in the cell can be either a
date or a check number. When I enter the date, I would like for it to
come up as 4/26 and not 26-Apr. Is there a way to make Excel use a
different format than the 26-Apr format? The cells are defaulted to
General. I am using a macro to change the date format in the cell where
this happens now. This is on Excel '04 using Mac 10.3.9 on a G4
powerbook.

If the cell could be either a General format for check number or a date,
try (assuming your check numbers are <30000):

Format/Cells/Number/Custom [<30000]General;m/dd

Thanks JE. I will give that a try.