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) |