Displaying Number part of date in cell

[Gunjani]

A Row of cells formatted in Date 01-Mar-04 but in the cells I only want
the '01' part displayed. This is so my column width size is reduced.
Note I don't care what date format tthe cells are in just so long as the
month and year is not diplayed.

In case u r wondering, I don't want to format as 'General' or 'Numbers'
because I wish to exclude the row in a Formula which contains data
formatted in General & Numbers.

--
Many Thanks

Gunjani
Time flies like an arrow. Fruit flies like a banana.
-- Groucho Marx

 

[Andy B]

Hi

Format the cell as Custom - and type dd in the Type box

 

[Peo Sjoblom]

Try custom format dd

 

[DNF Karran]

set the custom format to mm

Alternatively =DAY(-DATE-)

Dunca

 

[Gunjani]

Hi

Format the cell as Custom - and type dd in the Type box

Tried that already but it displays 03/01/1900 (3rd Jan 1900)in the Cell
--
Many Thanks

Gunjani
In the mad rush to choose the Person of the Century:
"For every self-respecting person, there is no wiser course
of action than to designate himself or herself as the
Person
of the Century. The Universe is within, as without, and so
is its center."

 

[Gunjani]

Try custom format dd

Tried that already but it displays 03/01/1900 (3rd Jan 1900)in the Cell
--
Many Thanks

Gunjani
Helpful Hint:
A mouse trap, placed on top on of your alarm clock, will
prevent you from rolling over and going back to sleep.

 

[Gunjani]

Hi

Format the cell as Custom - and type dd in the Type box

SORRY... it works... SORRY,SORRY,SORRY,SORRY,SORRY,SORRY,SORRY,SORRY,
--
Many Thanks

Gunjani
You will never get to where you want to be on dead hopes
or hopeful wishing.

 

[Gunjani]

Try custom format dd

SORRY... it works... SORRY,SORRY,SORRY,SORRY,SORRY,SORRY,SORRY,SORRY,

 

[Gunjani]

set the custom format to mm

Thanks, but it give the month but I got the gist... Thank anyway.

Alternatively =DAY(-DATE-)

? How, entered the above in cells but had no affect accept dipaying the
above formula!

Duncan

--
Many Thanks

Gunjani
You are the only real obstacle in your path to a fulfilling
life.
-- Les Brown