ExcelBanter - a number is replaced by text when inserted anywhere in the sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - a number is replaced by text when inserted anywhere in the sheet (https://www.excelbanter.com/excel-programming/343898-number-replaced-text-when-inserted-anywhere-sheet.html)

Marga

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.

Kleev

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.

All times are GMT +1. The time now is 05:59 PM.