Formatting any number to look a certain way

[Im_Offset]

Hello to everyone who is kind enough to open my thread and will try to help me!

I'm sure my answer involves the text() function, but I'm not knowledgeable on how to tell excel how to format the result the way I need it.

See the attached spreadsheet for a visual representation of my question.

I'm trying to convert a number (i.e. $133.50) so that it is read with a total of 8 digits. The first 5 digits would be everything to the left of the decimal and would have a 0 if not represented in the original figure. The last 3 digits would be the numbers to the right of the decimal and, again, 0 would be used for anything not in the original number. Lastly, the decimal point would be omitted all together.

So, if $133.50 is analyzed by this formula, the result would be 00133500

How can I do that?

Thank you because
Im_Offset

 

[shrivallabha]

Not sure if I follow the logic but based on the sample data & result following will work assuming data in A1:
=RIGHT(REPT("0",8)&(A1*1000),8)

 

[Norm Dziedzic]

This should do it. This only gets the first one but you should see the process:

=TEXT(B3*1000,"00000000")

 

[Im_Offset]

This should do it. This only gets the first one but you should see the process:

=TEXT(B3*1000,"00000000")

Thank you! Sometimes the simplest of things will trip me up.