| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write a number in a cell as text
Line 1: Cells(1,1)=ticker
enters the value of ticker in cell A1. If ticker = "1" AND format of A1 is General line 1 results in A1=1 as a number NOT as text, even though ticker is a string Is there a way to force the writing of ticker in A1 as text, WITHOUT CHANGING THE FORMAT OF A1 TO TEXT? This is quite relevant for me because the VLOOKUP function won't work otherwise and the spreadsheet where A1 is located cannot be modified. I have tried CStr() but makes no difference. In a General format cell Excel changes a numeric string to a number. Thanks, Antonio |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I write a number in an Excel cell with zero at the begin | Excel Discussion (Misc queries) | |||
| how to write 1234567890123456789 into a cell with number format | Excel Discussion (Misc queries) | |||
| Write a number in a cell and another number comes out in another c | Excel Worksheet Functions | |||
| How to write/Remove some text (Like Page Number/ Confidential) @ s | Excel Discussion (Misc queries) | |||
| how do write the amount of a number in text? | Excel Worksheet Functions | |||
Threaded Mode
