Date format

[Wally]

I have two sheets that includes the date m/d/y which is to be transferred
to the second sheet. If a date isnt entered on the first sheet I want it
show as blank on second sheet. Right now it is showing 1/0/00. how can I
change this?

Thanks

 

[Frank Kabel]

Hi Wally
try the following fomule on your second sheet
=IF('sheet1'!A1="","",'sheet1'!A1)

 

[Mark Rosenkrantz]

Wally;

You can give a cell only four !!! kinds of numberformat.
Yours is a date format.

You can have a peek at my website: www.rosenkrantz.nl

Excellent Files | Tips | Books & Sheets | Custom Number
Formats.

It will come clear what options you have.

Mark.

More Excel ? www.rosenkrantz.nl or [email protected]