| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a number is replaced by text when inserted anywhere in the sheet
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
Hi
Create a custom format (FormatCellCustom), like # ##0\ "Text" Arvi Laanemets "Marga" wrote in message ... 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 Worksheet Functions | |||
| Text replaced with # | Excel Discussion (Misc queries) | |||
| text replaced by #### | Excel Discussion (Misc queries) | |||
Linear Mode
