How can I remove leading zeros?
try this if the cell in B2 had your example
=SUBSTITUTE(B2,"0","") -- Gary "AccessHelp" wrote in message ... Hello, I have a field with values "AAAA", "0AAA", "00AA", and "000A". I want to remove leading zeros on the ones with leading zeros. For example, "0AAA" will turn into "AAA". Can someone help me with the formula? I have tried using "Val" and "Str", and they don't seem to work. Thanks. |
All times are GMT +1. The time now is 09:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com