Displaying Number part of date in cell

G

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
 
G

Gunjani

Hi

Format the cell as Custom - and type dd in the Type box
Click to expand...
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."
 
G

Gunjani

Try custom format dd
Click to expand...
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.
 
G

Gunjani

Hi

Format the cell as Custom - and type dd in the Type box
Click to expand...
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.
 
G

Gunjani

DNF Karran said:
set the custom format to mm
Click to expand...
Thanks, but it give the month but I got the gist... Thank anyway.
Alternatively =DAY(-DATE-)
Click to expand...
? How, entered the above in cells but had no affect accept dipaying the
above formula!
Duncan
Click to expand...

--
Many Thanks

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