Date Format

  • Thread starter Thread starter RE: VLOOKUP fORMULA
  • Start date Start date
R

RE: VLOOKUP fORMULA

Any one pls help....

Is there any way to show only the date (dd) in a cell.
I have a date formatted cells from (A9:ZZ9).

tks in advance
 
Hi,

Select these cells and apply a custom format of DD

To apply the format right click the selected cells - Format - select Custom
and enter DD in the TYPE box. OK

Mike
 
Try giving the cell a custom format of:
dd
or
d
(depending on if you want leading zeros for days 1-9.)
 
Back
Top