Remove Quotes around Power Pivot data - drops leading zero

[Graham T]

Hi,

I've been asked to look at something for a college, who is attemting to run a macro to format some data that derives from Power Pivot.

[TABLE="width: 183"]
<TBODY>[TR]
[TD]"05014297"</SPAN>
[/TD]
[TD="align: right"]5014297</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]


In the first column, which comes from Power Pivot there are quotation marks around the data. If I remove this (just via find and replace) this will drop the leading zero from the data.

Is there a simple way around this that they can add to the macro to perform this action?

Thanks,

GT

 

[BrianMH]

You need to format the cell as text before you remove the quotes or if you want it to show the leading 0 then the numberformat needs to be set to 00000000

 

[Graham T]

Brian,

Thanks, this has sorted it.

GT