| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a number is replaced by text when inserted anywhere in the sheet
Excel 2003 : I want to assign text to a numerical number. The text must be
displayed when the number is inserted into a cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
a number is replaced by text when inserted anywhere in the sheet
I just tried this and it worked: (format cell custom)
#"sometext" Here are some numbers formatted with the above: 1234sometext 5sometext 15sometext 99992552sometext "Marga" wrote: Excel 2003 : I want to assign text to a numerical number. The text must be displayed when the number is inserted into a cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a max number of columns that can be inserted in a sheet | Excel Discussion (Misc queries) | |||
| Why won't the number 9 enter as that and gets replaced with 0 ins | New Users to Excel | |||
| a number is replaced by text when inserted anywhere in the sheet | Excel Programming | |||
| a number is replaced by text when inserted anywhere in the sheet | Excel Worksheet Functions | |||
| Text replaced with # | Excel Discussion (Misc queries) | |||
Linear Mode
