Hi All,
I have a PDF file (Static) that I will like to add to sheet 2 and populated with totals from, sheet 1.
The document is a 2 part NCR form it can not be sent from a printer.
Any suggetsions, Thanks
Dennis
This is the way is listed and written in the page when ordering a product:
Example:
1- 4.2 x 1.2 x.0.8 which equals 1pc. 4'2"L x 1'2"W x.08" H
so I need to convert it to say in a single cell 50, and in separate cell 14
Hope this is clear
Thanks
Hi All
Need to convert the following : 2.0 to 24 & 3.0 to 36 This is the way I receive it and need to convert it as indicated.
I try =(LEFT(B2,1)*12)+(RIGHT(B2,1)) but I get 26 and 39
Please advise
Thanks Dennis