Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using VBA remove "0" but leave "X" first digit only please.
Hello from Steved
Col B:B Column format is General 0702301 to become 702301 but if it has an X702301 please ignore Yes I'm only requiring the first digit of the cell to be changed ie delete "0" if it has an "X" ignore it and find the next "0" The bottom is similar as to what I'm trying to acheive please Sub removezero() Range("B2:B250").Formula = "=required Formula please" End Sub Thankyou |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |