Share via

Remove specific digits in a number using a basic formula.

Anonymous
2024-05-21T11:27:28+00:00

Greetings I have a 11 digit characters that can begin with 0. I would like to remove the first character. For example 09978471485 would become 9978471485.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-05-21T11:45:49+00:00

    =--A1

    for example. If you need the digits to remain as text, then you can use:

    =TEXT(--A1,"0")

    Was this answer helpful?

    0 comments