Posted to microsoft.public.excel.programming

TB[_3_]

external usenet poster

Posts: 10

Date string question

Is there any way to alter the following expression to return a double digit
for single digit months (i.e. 08 instead of 8) without adding more lines of
code?

strMonth=Month(Range("A4").Value)

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
Convert Date string to date format	Joe M.	Excel Discussion (Misc queries)	7	May 6th 10 02:46 PM
Excel String question	Practiceguys	Excel Discussion (Misc queries)	4	January 8th 08 08:49 PM
Date String	Jester	Excel Discussion (Misc queries)	1	February 28th 07 10:00 AM
extract date from string	kdp145	Excel Worksheet Functions	3	March 3rd 06 02:54 PM
Finding a string/using adjacent data question	[email protected]	Excel Discussion (Misc queries)	4	January 9th 06 03:59 PM

All times are GMT +1. The time now is 05:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us