Posted to microsoft.public.excel.programming

Corey

external usenet poster

Posts: 172

Date Value in wrong format on userform

I have a textbox that displays the value of a cell(E2), but the worksheet displays:
31 October 2006, yet the userform textbox value shows 10/31/06.
Is there a way i can change this to display as the sheet view (31 October 2006) ?

Corey....

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
from date format convert to text format is wrong	nooris	Excel Discussion (Misc queries)	2	February 4th 10 03:41 PM
date in wrong format	Mike	New Users to Excel	3	November 15th 08 08:42 PM
Date in wrong format	GKW in GA	Excel Discussion (Misc queries)	6	February 19th 08 03:21 PM
Wrong date format in header	Curt Charles PDX	Excel Discussion (Misc queries)	1	October 25th 06 10:42 PM
Macro gives the wrong date format	chin_un_len[_13_]	Excel Programming	0	February 25th 06 12:46 AM

All times are GMT +1. The time now is 06:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us