How to convert numbers with apostrophe's (ex. 219'2) to decimals?
How to convert number with apostrophe's (ex. 219'2) to decimal format (ex.
219.25) |
=value(substitute(a1,"'","."))
|
Edit|replace
what: ' with: . replace all Kaci wrote: How to convert number with apostrophe's (ex. 219'2) to decimal format (ex. 219.25) -- Dave Peterson |
All times are GMT +1. The time now is 03:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com