Custom number format

  • Thread starter Thread starter ScoobyDoo
  • Start date Start date
S

ScoobyDoo

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


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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping through columns 2
Problem with date formatting 5
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Sumproduct 0
Referencing a cell as a row number 5
Determine number of rows with data 6
Alternative to blind formatting 6
If statement in VBA to change formatting from % to numbers 1

Back
Top