VBA changes my date format

Posted to microsoft.public.excel.programming

Xanny

external usenet poster

Posts: 1

VBA changes my date format

Thanks Bob,

Thats got it working fine.

thanks again.

On Sat, 1 Sep 2007 10:34:14 +0100, "Bob Phillips"
wrote:

See if this works

For Each cell In Range("b1:b1200")
If Left(cell.Value, 1) = "S" Then
nextrow = Range("O65536").End(xlUp).Row + 1
Cells(nextrow, 15) = CDate(cell.Offset(0, -1).Value)
Cells(nextrow, 16) = cell.Value
End If
Next cell

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
permanent conversion of 1904 date format to 1900 date format	Jos	Excel Worksheet Functions	4	November 26th 15 02:48 PM
change date format dd/mm/yyyy to Julian date format?	itzy bitzy	Excel Worksheet Functions	1	December 8th 09 07:42 PM
Convert date + time text format to date format	Paul Ho	Excel Worksheet Functions	2	May 22nd 07 05:47 PM
code to convert date from TEXT format (03-02) to DATE format (200203)	Gauthier[_2_]	Excel Programming	0	September 22nd 04 03:26 PM
Change a date in text format xx.xx.20xx to a recognised date format	concatenator	Excel Programming	1	November 24th 03 11:33 PM

All times are GMT +1. The time now is 10:07 AM.

Menu

About Us