| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove preceding zeros
have a series of data with preceding zeros of variable length in column
A2:A1000 eg. 000301, 0000034456 In column B what formula can I use to remove the zero so the result is 301, 34456 Bruce |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove preceding zeros
Bruce wrote:
have a series of data with preceding zeros of variable length in column A2:A1000 eg. 000301, 0000034456 In column B what formula can I use to remove the zero so the result is 301, 34456 Bruce =VALUE(A2) (Make sure the formatting of column "B" is set to anything value related, i.e. not "Text".) CoRrRan ----------- Change NOSPAM to GMAIL |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove preceding zeros
You can change it to number format.
Select your data, click on the information box on the top righ hand corner and convert the number. It automatically takes the zeros away. "Bruce" wrote: have a series of data with preceding zeros of variable length in column A2:A1000 eg. 000301, 0000034456 In column B what formula can I use to remove the zero so the result is 301, 34456 Bruce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do the preceding zeros disappear when I remove dashes? | Excel Discussion (Misc queries) | |||
| How do I format fields to show preceding zeros? | Excel Discussion (Misc queries) | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| Remove zeros | Excel Worksheet Functions | |||
| Preceding Zeros... | Excel Worksheet Functions | |||
Linear Mode
