Custom Number Format

V

Venkata Vijay

Hi

I need to handle the custom number format in excel programming and as such i
need any generalized way to handle all types of custom format

Can any one suggest me on this?

Venkata Vijay
 
V

Venkata Vijay

Hi

Basically i will get excel sheets which contains different custom number
formats and while trying to read data using macro, they are getting changed

For Example if in a cell i give value ="2008" and set custom number format
to yyyy, after reading the data from macro, its value is getting changed to
1905

Similar observations found with some other type of custom number formats

I need a generalized way by which i can handle this issue

Venkata Vijay
 
G

Gord Dibben

2008 alone is interpreted by Excel as a number.

The serial number 2008 is June 30, 1905


Gord Dibben MS Excel MVP
 

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

Text Formats 4
number format 3
Custom Number Format Excel 2003 7
Unable to format a control in a Userform 2
Excel 2003 toolbar with custom image 4
Custom number format 1
Custom Document Properties in Word documents and Excel workbooks 13
PivotTable Custom Field - formula for no value, with blank cell displayed? 6

Top