Thread
:
Formula for converting currency
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Formula for converting currency
Thanks Chip.
"Chip Pearson" wrote in message
...
Try formatcustom format0000000000 (or as many as you want)
That will eliminate the decimal portion of the number, not what the
original
poster requires.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
"Don Guillett" wrote in message
...
Try formatcustom format0000000000 (or as many as you want)
"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
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]