VBA code to change numeric value to string
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.
Hakan |
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 |
VBA code to change numeric value to string
On Monday, January 20, 2020 at 2:39:43 PM UTC+2, Claus Busch wrote:
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 Because that is only a presentation value - the real value will still remain numeric i.e. 100. 00100 is a zip code which will be forwarded to an external mail merging program. HÃ¥kan |
VBA code to change numeric value to string
On Monday, January 20, 2020 at 2:39:43 PM UTC+2, Claus Busch wrote:
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 Because that is only a presentation value - the real value will still remain numeric i.e. 100. 00100 is a zip code which will be forwarded to an external mail merging program. Håkan Zip Code is a built-in 'Special' format so typing 100 displays as 00100; - why not use it? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
=TEXT({number},"00000")
|
VBA code to change numeric value to string
On Wednesday, January 22, 2020 at 11:49:15 AM UTC+2, Lepista wrote:
=TEXT({number},"00000") -- Lepista Thank you. I'll give it a try. HÃ¥kan |
All times are GMT +1. The time now is 05:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com