Hi Guys,

Can you help me with a little problem.

I am running a macro on a csv file.
There are 4 dates in the format dd/mm/yy and I format them to dd mmm yyyy.
So the cell A1 originally has the value 25/12/05, I format it so the cell A1
now has 25 Dec 2005
When I try to concatenate "Date Reported : " & A1. Instead of getting Date
Reported : 25 Dec 2005 I get Date Reported : 25/12/05 Cell A1 is back in
it's original format although on the screen it is showing as the new format
I.E. 25 Dec 2005

What is going on here? how do I get the cell to keep it's new format so when
I use the value from the cell it's the correct format.

Thanks for your help.

Best Regards,

Steve Wilson.

Please don't post to multiple groups in separate messages.

See answer in other newsgroup

--
Kind regards,

Niek Otten

"Always Learning" <NoMoreSpam@MyEmail wrote in message
...
Hi Guys,

Can you help me with a little problem.

I am running a macro on a csv file.
There are 4 dates in the format dd/mm/yy and I format them to dd mmm yyyy.
So the cell A1 originally has the value 25/12/05, I format it so the cell
A1
now has 25 Dec 2005
When I try to concatenate "Date Reported : " & A1. Instead of getting
Date
Reported : 25 Dec 2005 I get Date Reported : 25/12/05 Cell A1 is back
in
it's original format although on the screen it is showing as the new
format
I.E. 25 Dec 2005

What is going on here? how do I get the cell to keep it's new format so
when
I use the value from the cell it's the correct format.

Thanks for your help.

Best Regards,

Steve Wilson.

Niek Otten wrote:

Please don't post to multiple groups in separate messages.

See answer in other newsgroup

This is an unfortunate approach for those of us who don't know what
other groups it has been posted to, but would have been interested in
the answer to the question.


--
Gordon Rainsford

London UK

Hi Gordon,

I also posted in the Microsoft.Public.Excel Group.

Got some good answers there too.
Main ones were
For VBA
HoldPrevYearDate = "Previous Year: " _
& Format(activeworkbook.worksheets("sheet99").range( "a1").value, "dd
mmm yyyy")
For Excel
HoldPrevYearDate = "Date Reported: "&TEXT(A1,"dd mmm yyyy")


Best Regards,

Steve Wilson.

"Gordon Rainsford" wrote in message
news:1h8lh5l.1h2kddapplefkN%grbridgeREMOVETHIS@bti nternet.com...
Niek Otten wrote:

Please don't post to multiple groups in separate messages.

See answer in other newsgroup

This is an unfortunate approach for those of us who don't know what
other groups it has been posted to, but would have been interested in
the answer to the question.


--
Gordon Rainsford

London UK

microsoft.public.excel

--
Kind regards,

Niek Otten

"Gordon Rainsford" wrote in message
news:1h8lh5l.1h2kddapplefkN%grbridgeREMOVETHIS@bti nternet.com...
Niek Otten wrote:

Please don't post to multiple groups in separate messages.

See answer in other newsgroup

This is an unfortunate approach for those of us who don't know what
other groups it has been posted to, but would have been interested in
the answer to the question.


--
Gordon Rainsford

London UK