The cell im working from is b3. it is formated under "date: march 98" I
need just the number of the month to appear in cell c3.


b3= october-04 then c3= 10
b3= november-02 then c3=10
etc..

Any Ideas?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472611

try =month(b3)

does that work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=472611

Hi

One way, in cell C3
=B3 and format cell C3 as FormatCellsNumberCustom mm

Regards

Roger Govier



comotoman wrote:

The cell im working from is b3. it is formated under "date: march 98" I
need just the number of the month to appear in cell c3.


b3= october-04 then c3= 10
b3= november-02 then c3=10
etc..

Any Ideas?

no that didnt work, i got custom format "M" to work though. Thanks


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472611