| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to strip dashes out of numbers in a variable
Bernie Deitrick wrote: You're right that I didn't need it - but CStr doesn't add a space: Dim myVal As Long myVal = 2314 MsgBox Len(myVal) = Len(CStr(myVal)) Could you post code that shows that it does? HTH, Bernie MS Excel MVP No, I was right the first time - I'm being pretty dumb. Str adds a leading space, not CStr. My bad. Iain |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to change numbers with dashes to numbers with no dashes | Excel Discussion (Misc queries) | |||
| How do I strip just numbers from an alphanumeric cell? | Excel Worksheet Functions | |||
| removing dashes from numbers | Excel Worksheet Functions | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
