ExcelBanter - View Single Post - How to convert numbers with apostrophe's (ex. 219'2) to decimals?

Thread: How to convert numbers with apostrophe's (ex. 219'2) to decimals?

View Single Post

#2

Report Post

arno

Posts: n/a

Default

=value(substitute(a1,"'","."))

Reply With Quote

Reply With Quote