Click FORMAT in the menu and select CELLS. Click the NUMBER tab and in the
CATEGORY column locate and select CUSTOM. In the TYPE field to the right of
the category column enter one of the following format masks. Be sure to
enclose the # with quotes on both sides.

"#"#

or

"#"#,##0
or
"#"#,##0.00

Cl
--
Kevin Backmann


"imsadrian" wrote:

I need the "#" inserted in front of existing number when i use the insert it
puts it at the end.