Missing zero's

  • Thread starter Thread starter Nola
  • Start date Start date
N

Nola

I'm trying to format the cell to accept a 0302 number. I
can enter it into each cell manually with the cell set to
text. But when I try to find 302 and replace with 0302 it
won't change it to 0302. All cells are set to text. and
302 is currently showing in the cells. Why won't it let
me find them and replace them with the correct number?
 
Nola,

If you want "four" digits, go

Format | Cells | Number | Custom "0000" without the quotation marks.

The "number" will be a number and not text.

Regards,
Kevin
 
Thanks, that works :)
-----Original Message-----
Nola,

If you want "four" digits, go

Format | Cells | Number | Custom "0000" without the quotation marks.

The "number" will be a number and not text.

Regards,
Kevin






.
Click to expand...
 
Nola,

I appreciate your thanks. I am glad you're on your way.

Your welcome.

Regards,
Kevin
 
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

Run-time error '457' 2
Numbers change in cell even when formatted as text 4
Subtraction of date 3
Displaying zeros in cells 2
problem with fractions to decimal 1
vlookup + indirect formula 6
Question about conditional formatting of zeros in Excel 0
Find/Replace Numbers stored as Text drops zeros 1

Back
Top