This is driving me crazy..

I have a column with data that looks like this:

2Dec5255

It is not a date but EXCEL treats it like a date,. When I enter the
value into an excel
cell it shows up as 2-Dec-55.

The code I am currently use is

Columns("B:B").Select
Selection.NumberFormat = "ddmmmyy"

I need a custom number format that I can put in to display the numbers
correectly.

Thanks

columns("B:B").numberformat = "@" 'text



ScoobyDoo wrote:

This is driving me crazy..

I have a column with data that looks like this:

2Dec5255

It is not a date but EXCEL treats it like a date,. When I enter the
value into an excel
cell it shows up as 2-Dec-55.

The code I am currently use is

Columns("B:B").Select
Selection.NumberFormat = "ddmmmyy"

I need a custom number format that I can put in to display the numbers
correectly.

Thanks

--

Dave Peterson