| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
zeros are being added to my numbers
Hi when i type a number into a cell ie 6 when i leave the cell a zero is
automatically added. I dont want this zero to be added -- des |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
zeros are being added to my numbers
In front or at the end?
Check: a. Tools|Options|Edit tab, uncheck Fixed Decimal b. Format the cell as General -- Kind regards, Niek Otten Microsoft MVP - Excel "des" wrote in message ... | Hi when i type a number into a cell ie 6 when i leave the cell a zero is | automatically added. I dont want this zero to be added | -- | des |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
zeros are being added to my numbers
Hi Niek Otten your fix worked Thanks
-- des "Niek Otten" wrote:. Hanks In front or at the end? Check: a. Tools|Options|Edit tab, uncheck Fixed Decimal b. Format the cell as General -- Kind regards, Niek Otten Microsoft MVP - Excel "des" wrote in message ... | Hi when i type a number into a cell ie 6 when i leave the cell a zero is | automatically added. I dont want this zero to be added | -- | des |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| added up none numbers | Excel Worksheet Functions | |||
| How do I keep the zeros in front of numbers when i split a cell | Excel Worksheet Functions | |||
| finding the no. of rows in a COL filled with numbers, zeros and bl | Excel Worksheet Functions | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Linear Mode
