formatting a cell

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

Guest

I want to put the number 017904 in a cell and it truncates the 0. I was told
to put a '017904 and that works, but isn't there an easier way than
remembering to put the ' in front of the number?
 
Set the cell format to 000000

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

How can I keep a zero at the beginning of a mobile number? 3
Numbers showing Up Centered in Cell ? 1
Maximum amount of numbers in one Cell 2
Truncate a data entry cell 3
For Joey2004 et al. From OP: Re Appending Question 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Center text in Excel 03 cell by using the keyboard? 3
Set a value in multiple cells based on a condition 2

Back
Top