Sorry I read too quickly. I thought you mean to add the second formula to
formatting. It does work if it's put into the actual cell. thanks

"jamescox" wrote:


You didn't mention what version of Excel you are using so it's hard to
give you a menu path to get where you need to be.

Basically, do a Format Cells on the range you are concerned with,
select Number format and set the number of decimal places you want
displayed.

Dealing with zeros is a bit harder. There is a workbook-wide setting
that will suppress the display of zeros, but that may be a bit extreme.

A cell formula like

=IF( 'Master-H'!AW105 = "", "",'Master-H'!AW105)

would do it if entered in your range of interest.


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111553