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
 
That worked. Thanks! I was trying that but didnt use the quote marks. Thanks
again.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Symbol Insertion In Cell 1
vba macro that allows insertion of symbols at cursor 0
How to insert symbols if you don't have a symbol menu? 1
Temperature (degree) symbol 2
VBA - retrieve data on last create named range from previous inserted named range 0
Alt codes 4
trying to insert a 0 in front of zipcode 2
Can no longer instert symbol in text box 1

Back
Top