Formula for converting currency
Clay,
You can use a formula like =TEXT(A1*100,"000000000") -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Clay" wrote in message ... Hello, I am not too good with Excel formulas, hopefully one of you can help! I have a column currency amounts as shown below. 8631.36 40729.54 47749.70 189.12 I need to write a formula that will convert this to a 9 digit, non-decimal number. So, after the formula, I need the above to look as shown below: 000863136 004072954 004774970 000018912 Than You in advance! Clay |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com