Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula is entering a default time when it comes across an empty cell..
I'm using a formula to copy a time from one cell to another
across sheets. The format of the time is h:mm AM/PM. However, when the formula references an empty cell, it puts in a default value of 12:00 AM and I need it to remain blank, (just as the referenced cell) It's such a simple copy formula. ie: =sheet1!A1 I can't see anything causing this. Has anyone any ideas? thanks in advance, Howard. -- Howard Coakley e-mail... howard<dot}coakleyatcoakley<dot].codotuk Skype ID: howie10 (get skype from www.skype.com) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for a time card | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
How do I make a cell appear empty when the formula = 0? | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions |