ExcelBanter - Convert NumberFormat to System.Type

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Convert NumberFormat to System.Type (https://www.excelbanter.com/excel-programming/403891-convert-numberformat-system-type.html)

Andrew HUANG

Convert NumberFormat to System.Type

Hi, all,

I have problem about cell's format. How to know a cell's format is DateTime?
I use cell.NumberFormat, it can return many types, such as "[$-F800]dddd,
mmmm dd, yyyy".

Thanks,
-Andrew

Andrew HUANG

Convert NumberFormat to System.Type

By the way, using C#.

"Andrew HUANG" wrote:

Hi, all,

I have problem about cell's format. How to know a cell's format is DateTime?
I use cell.NumberFormat, it can return many types, such as "[$-F800]dddd,
mmmm dd, yyyy".

Thanks,
-Andrew

All times are GMT +1. The time now is 02:34 PM.