Re: Cell Value & unchanging Date With Macro run


Hi Tim,
Ok Its working kinda. Im getting the correct format but this is whats
displaying in the cell:
453 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22
01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22

he he he. i will work on it tonight and see what i can figure out.

Does the fact that is every other cell (or row) have any thing to do
with this result?

Thx much,
Dave
Desert Piranha Wrote:
> Hi Tim,
> Thx for responding. I will check this out and get back as i have to
> leave for about an hour.
> BUT it will always be values (text or numbers) no formulas.
>
> Thx Again
> Dave


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28934
View this thread: http://www.excelforum.com/showthread.php?threadid=503878

.

Relevant Pages

  • Re: Cell Value & unchanging Date With Macro run
    ... maybe your "empty" cells aren't really empty. ... "Desert Piranha" ... > Does the fact that is every other cell have any thing to do ... >> Thx for responding. ...
    (microsoft.public.excel.programming)
  • Re: Cell Value & unchanging Date With Macro run
    ... Hi Tim, ... Thx for responding. ... > You would run this directly after the copy-paste routine. ... Desert Piranha ...
    (microsoft.public.excel.programming)
  • Re: Userform help needed
    ... This has me heading in the right direction, ... > Same link as above Tim, ... >> and then run Ron's macro. ... >>> N7 gets incident number from a cell on another sheet and that data is ...
    (microsoft.public.excel.programming)
  • Re: Format cells so they display numbers as negatives
    ... takes the previous column and multiplies by -1. ... "Tim" wrote in message ... I would like to format the cell so that it displays this number as a negative. ... Is there a way to automatically format a cellso that it only displays negatives? ...
    (microsoft.public.excel.misc)
  • Re: and ^ everywhere
    ... > " makes it text and right justifies it. ... >> Can anyone explain why either ' or ^ is in every cell within a workbook. ... >> The characters do not effect formulas or numbers they're more like hidden ... >> Tim in Porltand ...
    (microsoft.public.excel)