Hi Beth

the same as in earlier versions of Excel
FormatCellNumberCustom 0.0 "ft"

Set the number of decimal places you want as appropriate.
25 entered in the cell will show as 25.0 ft with the above format. All that
is stored is the number 25, which can be used in subsequent calculations.
--

Regards
Roger Govier

"bethgames" wrote in message
...
Can someone help with this in Excel 2007??