| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update this macro to make it generate a counter as text
Hi,
Am Thu, 18 Oct 2012 08:21:13 -0700 (PDT) schrieb B Roberson: I thought this solution would fix both my columns, and it did for the one that was strictly working off the rows. I have another field that is numeric and its values are almost always the numeric 1 or 4, and they need to convert to text also, with the 1 being 01, and the 4 being 04. You can display it that way all you want with .NumberFormat = "00" but that is only for display, its still a numeric field with this in there. If I were doing this on a cell and copying it down, it would be a formula in B1 with something like =text(A1,00) =TEXT(A1,"00") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to generate a text file from Excel using a macro or script | Excel Programming | |||
| How to generate a text file from Excel using a macro or script | Excel Programming | |||
| How to generate a text file from Excel using a macro or script? | Excel Discussion (Misc queries) | |||
| How to generate a text file from Excel using a macro or script? | Excel Discussion (Misc queries) | |||
| Generate Numbers (not random) Like a counter | Excel Discussion (Misc queries) | |||
Threaded Mode
