Thread
:
Formula for converting currency
View Single Post
#
1
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson