Excel Decimal Point

C

curran

Hi
Using the following formula " =HLOOKUP(B3,$B$6:$AW$11,2,FALSE) " and
linking to this number 0.813 but it rounds it up to 1. Can any one
tell me how to disable this feature.

Thanking in advance
 
D

Dave Peterson

Or widen the column to see the value.
Hi
Using the following formula " =HLOOKUP(B3,$B$6:$AW$11,2,FALSE) " and
linking to this number 0.813 but it rounds it up to 1. Can any one
tell me how to disable this feature.

Thanking in advance
Click to expand...
 
Top