can a symbol be inserted in front of existing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need the "#" inserted in front of existing number when i use the insert it
puts it at the end.
 
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
 
Back
Top