| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to change numeric value to string
Hi Hakan,
Am Mon, 20 Jan 2020 04:36:43 -0800 (PST) schrieb hbj: The values entered in a column should always be of string type. If the user enters a numeric value it should be changed to string. Example: if the user enters 100 it should be presented as "00100". I have tried a code into Worksheet.Change() with Cells(TargetRow,TargetColumn).value = "00100". The cell value does not change. why don't you use a custom number format: 00000 Regards Claus B. -- Windows10 Office 2016 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text string to Numeric string | Excel Discussion (Misc queries) | |||
| string and numeric | Excel Programming | |||
| How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
| Find numeric value at end of string | Excel Worksheet Functions | |||
| Find first numeric value in text string | Excel Worksheet Functions | |||
Threaded Mode
