Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

payton50325@yahoo.com - 26 Apr 2005 22:35 GMT

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.

Reply to this Message

CyberTaz - 26 Apr 2005 23:48 GMT

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 |:>)

On 4/26/05 5:35 PM, in article
1114551347.695219.139930@z14g2000cwz.googlegroups.com,

> 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
[quoted text clipped - 3 lines]
> this happens now. This is on Excel '04 using Mac 10.3.9 on a G4
> powerbook.

-- generaltaz1@comSpaMcast.net

Reply to this Message

JE McGimpsey - 27 Apr 2005 12:46 GMT

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

Reply to this Message

payton50325@yahoo.com - 28 Apr 2005 21:37 GMT

> > 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
[quoted text clipped - 8 lines]
>
> Format/Cells/Number/Custom [<30000]General;m/dd

Thanks JE. I will give that a try.

Reply to this Message

Mac Forum / Applications / Excel / April 2005

Date Format