Jump to content

Recommended Posts

Posted

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.

Posted

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

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted

Note that this flag only works for a single cell. 

My UDFs and Tutorials:

  Reveal hidden contents

 

  • 2 weeks later...
Posted
  On 10/19/2016 at 6:09 AM, water said:

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

Expand  

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

Posted

Did you only read a single cell?

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted

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

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted
  On 10/31/2016 at 9:14 PM, 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.

Expand  

Ok, was hoping that was not the case.

Posted

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.

My UDFs and Tutorials:

  Reveal hidden contents

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...