Help with numbers

T

texraid1

How do you lead of with a zero on a spreadsheet? For example, 000635.
Excel wants to delete the zeros with just 635 in the cell.
TIA
 
J

John

Hi
You can start by formatting your cells as "Text" or you can start typing
your numbers with an apostrophe e.g '00234.
The apostrophe will not show in the cells
HTH
John
 
S

Shane Devenshire

Hi,

If you want to display 6 digit always then highlight the range and choose
Format, Cells, Number tab, Custom and enter 000000 in the Type box.
 

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

Using numbers in a cell 1
Integrating information from Word to Excel (not mail merge) 1
Keeping Leading Zeros; How Please ? 2
Excel does not accept text format! 0
Leading Zeros; How to Keep ? 2
Need Help with Macro Security 1
Excel - Wich Function should I use? 1
A useful AVERAGE calculation without using the built-in AVERAGE function 3

Top