Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom number format
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom number format
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cell custom Number format | Excel Worksheet Functions | |||
convert number to % using only custom number format challenge | Excel Discussion (Misc queries) | |||
Custom number format for driver's license number | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions |