| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with numbers
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with numbers
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 wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with numbers
On entry, precede the value with a single quote.
-- Gary''s Student - gsnu2007L " wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with numbers
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "John" wrote: 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 wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Linear Mode
