Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jul 6 07:49:04 CDT 2004
On 6 Jul 2004 at 14:35, paul.hartland at fsmail.net wrote: > To all, I have some data in an Excel sheet (4.26, 3.04 etc) what I want > in the column next to it is just the Decimal places part of the number > (26, 04 etc). I'm sure that there is a way to do this but can't for > the life of me think what it is. Paul > Assuming the number is in A1, in B1 put: (A1-Int(A1))*100 You will also need to format the cells as "Custom" with a Type of "00" to maintain the leading zeros. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.