Add a Zero

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I need to add a zero in front of 3,000+ different
records...is there a way to do them all at once. Thanks.
DaveB

HAVE:
Cell A1: 60244
Cell A2: 82774
Cell A3: 17863

WANT:
Cell A1: 060244
Cell A2: 082774
Cell A3: 017863
 
Hi
- select the cells
- apply the following custom format to these cells:
000000
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Creating Excel Formula 4
Function to add 3 column (of YES) to give a total % complete 7
Date/Time concatenation 4
Calculations 1
Adding recognised Zeros 5
Creating a formula relating to several cells 2
excel formula 1
How to I set a limit on the value returned by a cell 3

Back
Top