Text extraction using numbers MID()

[heatwave]

I am trying to extract a text based on a cell containing a number set to 3 decimal places, ie. A1 = 7.140

I have been using the following formula - MID(A1,1,1)&MID(C13,3,3)&"0" which yields 7140.

The goal is to extract all four numbers sequentially excluding the decimal (it is used as an automated text feed for another long formula), ie. want:

7.142 => 7142
7.140 => 7140
7.700 => 7700

The problem is the formula above falls apart for the first and third example where 7.142 outputs 71420 and 7.700 outputs 770.

Is there any other function that can read the character 0?

[6StringJazzer]

How about

=A1*1000&""

[6StringJazzer]

But maybe I don't understand your example, you are mixing references to A1 and C13 in the same formula. Why are you grabbing from two different cells?

[heatwave]

Hey Jazzer, thanks for the reply. I figured it out as well (*1000) 10 mins after I posted this thread. How do you delete a thread?? I cannot seem to locate the delete button or link anywhere.

[pike]

hi heatwave,
No need to delete it just
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save