Converting text into a number

[howard]

I have the following formula that pull a value from anotther worksheet. However, for some unkown reason it does not recognise the value as as number
=OFFSET('ECM & Volvo'!A474,0,Journals!$D$1-1)


I would like a formula to convert the value into a number

Your assistance will be most appreciated

 

[Kaps_mr2]

have you formatted the cell as a number ?

 

[repairman615]

you could try to add 0 to the end

=Your formula+0

 

[howard]

Hi Guys

Thanks for the help, much appreciated. The cell was formatted as a number. Jeff's solution by adding a 0 after the formula sorted out the problem.