Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove leading zeros | Excel Discussion (Misc queries) | |||
REMOVE LEADING ZEROS | Excel Worksheet Functions | |||
Remove leading zeros from column | Excel Discussion (Misc queries) | |||
How to remove leading zeros using excel 2000 | Excel Discussion (Misc queries) | |||
Using VBA to remove leading zeros | Excel Programming |