_Excel_RangeRead Strips Number Formating?

[chobo2]

Hi

I am using _Excel_RangeRead from Excel UDF. I noticed when it reads in my data it strips out number formating? Do I have set an option to stop this from happening?

Example --> 1,000.00 is what I see in excel. Once _Excel_RangeRead has read in the excel row I see 1000

_Excel_RangeRead($excelWorkbook, $worksheetName)

Is what I am using.

[water]

The function now retrieves the value. To retrieve the format please check the help file for _Excel_RangeRead. 

[Anoop]

_Excel_RangeRead ( $oWorkbook [, $vWorksheet = Default [, $vRange = Default [, $iReturn = 1 [, $bForceFunc = False]]]] )

Change $iReturn to 3 and try.

[water]

Note that this flag only works for a single cell. 

[chobo2]

On 10/18/2016 at 11:09 PM, water said:

The function now retrieves the value. To retrieve the format please check the help file for _Excel_RangeRead. 

Do you mean I should use the flags? As I tried all of them I did not see anything else about formatting. 

[water]

Did you only read a single cell?

[chobo2]

Just now, water said:

Did you only read a single cell?

No I am reading the entire worksheet in at once. 

[water]

Doesn't work. As I posted in #4: "Note that this flag only works for a single cell."
That's a limitation of Excel.

[chobo2]

Just now, water said:

Doesn't work. As I posted in #4: "Note that this flag only works for a single cell."
That's a limitation of Excel.

Ok, was hoping that was not the case.

[water]

I have never tried it but you could access the NumberFormat property (https://msdn.microsoft.com/en-us/library/ff196401(v=office.14).aspx) and try to format the returned values accordingly.