| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can a symbol be inserted in front of existing data
I need the "#" inserted in front of existing number when i use the insert it
puts it at the end. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can a symbol be inserted in front of existing data
Format Cells.. Number Custom "#"General
-- Gary''s Student - gsnu200754 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can a symbol be inserted in front of existing data
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can a symbol be inserted in front of existing data
That worked. Thanks! I was trying that but didnt use the quote marks. Thanks
again. "Gary''s Student" wrote: Format Cells.. Number Custom "#"General -- Gary''s Student - gsnu200754 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add a "0" (zero) to the front of existing data in cells | Excel Discussion (Misc queries) | |||
| Insert symbol in front of value | Excel Discussion (Misc queries) | |||
| Automatic Removal of 0's in front of data | Excel Discussion (Misc queries) | |||
| How do I add an apostrophe in front of existing column in Excel? | Excel Discussion (Misc queries) | |||
| Can inserted rows automatically include existing worksheet formula | Excel Discussion (Misc queries) | |||
Linear Mode
