Hi,

Am Sun, 15 Nov 2015 07:53:36 -0800 (PST) schrieb :

for eg: Cell A1: 67x89x6inch

I want each and every number must be multiplied by 2.54 (to convert in cm)

please look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "InchToCm"
There is an UDF to convert inches to cm.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional