Previous Topic Next Topic

Office for mac excel problem

Closed
bigratz - 17 Apr 2011 à 22:54
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Apr 2011 à 09:31
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
18 Apr 2011 à 09:31
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