Add decimal points to a number within a formula

[cecilia_is_the_best]

I'm trying to use CONCATENATE within an IF statement to display a number in a cell (ex. 00044 as 0.44) if the condition is fulfilled.

From the contents under Type and Mileage, I want the formula to produce the Title as shown below.

Type: Mileage: Title:
Geometry 00044 Geometry - Mi 0.44


So far I only have the following formula in the Title column...

=IF(A1="Geometry", CONCATENATE(A2," - Mi ",B2)"")

which would give me the title "Geometry - Mi 00044"

What do I add to get B2 to be displayed as 0.44 instead of 00044?

Thanks,

Cecilia

P.S. I can attach an example file if necessary

[JohnTopley]

Try

=IF(A1="Geometry", CONCATENATE(A2," - Mi ",B2/100)"")

[etaf]

b2 is text 00044
if so
b2*1 will convert to a number
so now you have 44
so you can now divide by 100
But do you always want the number divided by 100
what if b2 had

00444
what would you want then

[cecilia_is_the_best]

See attachment for example.

[cecilia_is_the_best]

So simple - can't believe I didn't think about that.

Thank you!!