Forum Discussion
Frank Kelly
Dec 30, 2017Copper Contributor
EXCEL HLOOKUP
Hi all
I have a problem with HLOOKUP. (EXCEL 365)
I need to copy a column of data from one worksheet to another.
My function works exactly as required EXCEPT:
The source column contains a pr...
SergeiBaklan
Dec 30, 2017Diamond Contributor
Hi Frank,
As variant in Excel Online you may apply custom format like this
And/Or if you have Excel Desktop to edit the file once applying any other custom format like
#,###;-#,###;@
it will be available in Excel Online after that.