Date format

  • Thread starter Thread starter Wally
  • Start date Start date
W

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
 
Hi Wally
try the following fomule on your second sheet
=IF('sheet1'!A1="","",'sheet1'!A1)
 
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 (e-mail address removed)
 
Back
Top