How do I keep leading zeros and format my cells as text?

G

Guest

I've formated the cells to have leading zeros using the custom category. But
I as need to format the cells to text. How do I accomplish both? Thanks!
 

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

Eliminate leading numbers - Excel 2007 2
How do I stop Excel from dropping leading zeros? 9
Replacing cell numbers but leaving leading zero 1
Leading Zeros 3
How to stop Excel from automatically truncating leading zeros 2
Add Leading Zeros 4
Need 7 digit number with differnt number of leading zeros 10
REPLACE command drops leading zeros 4

Top