AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,051
- Office Version
- 2019
- 2010
- Platform
- Windows
Cell type is General and holds a string like 02 33 or 1 02 33
I've used replace to fix "03:22" and done a check for a leading zero.
But I think there may be a more elegant method, perhaps Format or RegEx.
The value can be typed in by hand or data from a Recordset with VBA.
Could it also be trapped if the value can't be made?
I've used replace to fix "03:22" and done a check for a leading zero.
But I think there may be a more elegant method, perhaps Format or RegEx.
The value can be typed in by hand or data from a Recordset with VBA.
Could it also be trapped if the value can't be made?