If you want text returned:
=IF(B280.01,"01")

If you want the value to still be a number (not just digits in a text string),
you'll have to format the cell:

(xl2003 menus)
Format|cells|number tab|custom category
00

I'm kind of surprised you don't have an "else" portion in your formula:

=IF(B280.01,01,"not greater than 0.01")



Mick EXCEL newbie wrote:

I am reasonably new to Excel and having a couple of problems.
The first is the following which is probably to do with formatting.
=IF(B280.01,1) is what it keeps defaulting to yet what i need is
=IF(B280.01,01)

I have tried everything i can think of formatting wise, any ideas?

Many Thanks

--

Dave Peterson