Previous Topic Next Topic

Office for mac excel problem

Closed
bigratz - Apr 17, 2011 at 10:54 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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