Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
how do I convert a non exel tabulation to exel | New Users to Excel | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) |