date format

Teryl · May 15th, 2002, 12:59 PM

I have a cell linked to another cell which sometimes contains a date. When there is no date the linked cell reads (01/00/00) what I'd like is for the linked cell to read (0). I tried formatting the linked cell as text but this doesn't work. I hope someone can understand what I just said and advise me...Thanks

Juan Pablo González · May 15th, 2002, 01:18 PM

Try this format

dd/mm/yy;;0

You can replace the first part, "dd/mm/yy", with whatever you're using now.

Mark W. · May 15th, 2002, 01:19 PM

Or...

dd/mm/yy;;""

May 15th, 2002, 01:18 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Try this format dd/mm/yy;;0 You can replace the first part, "dd/mm/yy", with whatever you're using now. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 12:59 PM	#1
Teryl New Member Join Date: Feb 2002 Posts: 19	I have a cell linked to another cell which sometimes contains a date. When there is no date the linked cell reads (01/00/00) what I'd like is for the linked cell to read (0). I tried formatting the linked cell as text but this doesn't work. I hope someone can understand what I just said and advise me...Thanks

May 15th, 2002, 01:19 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Or... dd/mm/yy;;""