why is excel not showing the last digit ( if it's a zero) in my if statement

[bleeet]

hello

i made an if statement in my workbook and populates a number form a different cell. the problem i am having now is that if a zero is the last digit it will not show it but in the original cell it shows it. for example if the number is 11.40 in the cell it will populate in a different cell (the one with my if statement ) as 11.4

how can i make it show 11.40?

in my if statement i use "&F57&" to populate the number

 

[Colin Legg]

Use the TEXT function, eg.

"&TEXT(F57,"0.00")&"

 

[Robert Mika]

Just another thought:
Have you checked if the format is the same as in the cell where are you copy from?

You can always increase or decrease decimal using build in toll in Excel

 

[bleeet]

Use the TEXT function, eg.

"&TEXT(F57,"0.00")&"

this doesn't seem to work i keep getting an error


and by the way it will show the last digit if it's any other number but not when it's 0

 

[bleeet]

never mind got it to work thanks guys for the help