How can I write 3/5 in a cell and have it look like 03-May back?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janneman - 28 May 2008 07:56 GMT

Have tried to write in 3/5 and have it look like 03-May back, but excel
always comes back with 05-March! Have tried to format cells with both dates
and specials and also tried the "text to columns" but nothing works.
Anyone who can solve this problem?

Thanks!

Reply to this Message

David Biddulph - 28 May 2008 08:26 GMT

You may need to look at your date format settings in Windows/ Regional
Options (accessed through Control Panel, not Excel). Then try re-entering
the data.

Once the date is stored (as a number), reformatting the cell in Excel will
not change the underlying date stored.
--
David Biddulph

> Have tried to write in 3/5 and have it look like 03-May back, but excel
> always comes back with 05-March! Have tried to format cells with both
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message

Janneman - 28 May 2008 08:54 GMT

Thank you David!
This worked just fine!

> You may need to look at your date format settings in Windows/ Regional
> Options (accessed through Control Panel, not Excel). Then try re-entering
[quoted text clipped - 12 lines]
> >
> > Thanks!

Reply to this Message

David Biddulph - 28 May 2008 13:23 GMT

Glad it helped.
--
David Biddulph

> Thank you David!
> This worked just fine!
[quoted text clipped - 17 lines]
>> >
>> > Thanks!

Reply to this Message

Tim - 28 May 2008 08:29 GMT

Hi,

Right click the cell>Format>Custom>in the "Type:" box type: m/d

Tim

> Have tried to write in 3/5 and have it look like 03-May back, but excel
> always comes back with 05-March! Have tried to format cells with both dates
> and specials and also tried the "text to columns" but nothing works.
> Anyone who can solve this problem?
>
> Thanks!

Reply to this Message