LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How do I set up and use Month day, year format with other appl?

I enter example May 9, 1992 in the column and it appears as such, however, in
the fx line it appears as 5/9/1992. I want to use this inforamtion in a mail
merge but it is pulled into the file as m/d/yy? How can I correct this? I
am using Office XP excel 2002. I tried to format the cells to have the data
appear as May 9, 1992. It appears that way in the column but not in the fx
field. (the place where you can enter formulas.)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"