LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Converting Date 03/01/2010 into a simple Month

Is there a way to convert a numeric date 03/01/2010 into a single month
function? I have a worksheet that pulls in data from another worksheet, and
column A has a numeric date of 03/01/2010. Want to put a statement in column
B or where that only shows the month instead of the whole date field.
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM Peter Gonzalez[_2_] Excel Worksheet Functions 2 January 26th 10 06:58 PM
Problem Converting date to month in text for use in pivot table Peters Excel Worksheet Functions 2 October 31st 08 11:16 AM
Converting Day, Date Month Year format to MM/DD/YYYY 61Petrus Excel Worksheet Functions 1 February 19th 08 08:47 PM
Converting Month Number to Month Text Abbreviation Bob Excel Worksheet Functions 10 May 12th 07 04:11 AM
Converting a date field into a month-year only field C.Hirsch Excel Discussion (Misc queries) 1 April 25th 06 12:08 AM


All times are GMT +1. The time now is 05:17 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"