Is it possible to access cell custom formats?

Aug 17, 2011 at 7:57 PM

Hi

I am trying to read a sheet that uses custom formats in some cells. For example, a cell with format 00"/08", containing value 16. It appears in the sheet as 16/08 but is read as 16. Is it possible to either import the formatted text, 16/08, or get access to the custom format string?

 

Thanks

Geoff