Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Cubic Splines
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
- Downloads
- Daily Download 5: Frame Analysis
- XLDennis, the MSDN Library, and VBA rant
- The history of the theory of beam bending - Part 1
Recent Comments
Tag Archives: date formats
Dealing with dates 2: Getting cell data type and format code
When working with imported data, or data from an opened csv file, it is often important to know the data type that has been used to store the data. This may not be obvious, for instance in the previous post we … Continue reading
Posted in Excel, UDFs, VBA
Tagged Data types, date formats, Excel, Format codes, Number formats, UDF, VBA, [$-F800]
6 Comments