Date Format

P

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.
 
C

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.
Click to expand...

-- [email protected]
 
J

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.
Click to expand...

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
 
P

payton50325

JE said:
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.
Click to expand...

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
Click to expand...

Thanks JE. I will give that a try.
 
Top