Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys,
Hope you can help. I have a alphanumeic text column where some of the fields have a leading zero which i want to remove. I can't use the edit - replace option to remove the zero because other characters of that field might have a zero too. Is there a way programmatically or by a function to remove the zero if it is 1st byte? Any help and /or examples would be greatly appreciated. -- Thanks in advance, Matt (access 2000) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i change column header from R[1] C format to A1 format? | Excel Discussion (Misc queries) | |||
format cells in one column based on value in another column | New Users to Excel | |||
Format column to link file names in that column | Excel Discussion (Misc queries) | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions |