ExcelBanter - exel and times

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - exel and times (https://www.excelbanter.com/excel-discussion-misc-queries/212719-exel-times.html)

LOU

exel and times

I am trying to copy a group of cells formated for time. When one of the
cells have no value, the cell shows a "12:00 AM" in the copy to cell rather
than a blank cell as I need. Any suggestions?

Fred Smith[_4_]

exel and times

How are you copying? Copy and paste, a formula, fill handle, something else?
When you say a cell has no value, do you mean it's blank, it's null, or it
has zero in it?

Once we know exactly what you are doing, we can help determine the problem.

Regards,
Fred.

"Lou" wrote in message
...
I am trying to copy a group of cells formated for time. When one of the
cells have no value, the cell shows a "12:00 AM" in the copy to cell
rather
than a blank cell as I need. Any suggestions?

Mike H

exel and times

Hi,

It doesn't do that for me, more detail may help.

Mike

"Lou" wrote:

I am trying to copy a group of cells formated for time. When one of the
cells have no value, the cell shows a "12:00 AM" in the copy to cell rather
than a blank cell as I need. Any suggestions?

All times are GMT +1. The time now is 12:44 AM.