Office for mac excel problem

Closed
bigratz - Apr 17, 2011 at 10:54 PM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Apr 18, 2011 at 09:31 AM
Excel (Office For Mac) When trying to enter a date the letter "y" inserts itself into the date, no matter what format I use. I wish to enter the date as follows: 17 APR 2011 It becomes 17yapry11. Any suggestions how to correct this? Thkx

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Apr 18, 2011 at 09:31 AM
Hi Bigratz,

Check your cell properties by right-clicking the cell. I can replicate your result by using this type:
dd"y"mmm"y"yy
Change it to:
dd mmm yyyy
for the desired result.

Best regards,
Trowa
0