Leading "0"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a number in one cell, 0,108,250.500, to be without commas or
decimal place, 0108250500, in a new cell. I can make the change with no
problem to take out the commas and decimal (and this is done with a simple
macro, as there will be a long column of these numbers to convert), but I am
having problems figuring out how to get the leading "0".

Thanks for any help anyone can offer.
 
Format the cell as text before you put the number in, or format as
0000000000, or use =TEXT(A1,"0000000000")
 
Can you just give the range of cells a custom format to show leading 0's?

format|Cells|number tab|Custom category:
0000000000
 

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

Convert number to text as displayed 3
How specify number format of cell value in concatenate function? 1
leading and ending space 2
how replace comma with point in import data 1
count no. of times a character occurs in a cell 2
Access stripping decimal places in query 1
question related to merging multiple statements 5
CONCATENATE 3

Back
Top