Use Format Cells
select Number Tab
Select Custom
In the "Type" area, type your format
ie. # ###.###

Unfortunately, what you are trying to do may not be possible.
I tried about 10 or 12 different layouts, and they all failed to one
degree or another. The probelem lies in the fact that using a space
makes "Excel" think that the cell data is text, not a number as you
would expect.

You can simulate your format by putting as many "#" characters as the
largest value you expect to be entered.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=543599