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

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!

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

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

"Janneman" wrote in message
...
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!

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

Hi,

Right click the cellFormatCustomin the "Type:" box type: m/d

Tim

"Janneman" wrote:

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!

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

Thank you David!
This worked just fine!

"David Biddulph" wrote:

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

"Janneman" wrote in message
...
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!

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

Glad it helped.
--
David Biddulph

"Janneman" wrote in message
...
Thank you David!
This worked just fine!

"David Biddulph" wrote:

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

"Janneman" wrote in message
...
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!