L
LILA
HOW DO I PUT A ZERO IN FRONT OF MY NUMBERS EVERY TIME I GO TO NEXT CELL THE ZERO DISAPERS AND A COMMA APEARS I DONT WANT THIS??
HEL
THANKS
HEL
THANKS
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
first: please turn of your CAPS-Lock. It's considered as shouting in
newsgroups
Not quite sure about your issue but ry 'Tools - options - Edit' and
uncheck 'fixed Decimals'
first: please turn of your CAPS-Lock. It's considered as shouting in
newsgroups
Not quite sure about your issue but ry 'Tools - options - Edit' and
uncheck 'fixed Decimals'
N
Norman Harker
Hi Lila!
What numbers are you entering?
Format > Cells > Custom format
(eg)
0000.00
Will give an entry of 23 as 0023.00
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
What numbers are you entering?
Format > Cells > Custom format
(eg)
0000.00
Will give an entry of 23 as 0023.00
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
L
lila
I tried what you sugested it didnt work ill keep trying i apreciate the info
and sorry for the caps I didnt know I learn something new every day :O)
and sorry for the caps I didnt know I learn something new every day :O)
L
lila
Hi, Norman
I am brand new to this so I dont really know. I just opened excell and put a formula = in cells and typed my info and the zero's are just disapering. exam. 0321,0322 after I go to next cell it looks like this 321,0322. I put a space after the comma and it worked zero stayed but I dont want to put a space to mech info in one cell to be puting spaces
What am I doing wrong
thanks
lila
I am brand new to this so I dont really know. I just opened excell and put a formula = in cells and typed my info and the zero's are just disapering. exam. 0321,0322 after I go to next cell it looks like this 321,0322. I put a space after the comma and it worked zero stayed but I dont want to put a space to mech info in one cell to be puting spaces
What am I doing wrong
thanks
lila
N
Norman Harker
Hi lila!
Format > Cells > Custom format
In the top text box enter:
0000,0000
OK
That should give you 0321,0322
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Format > Cells > Custom format
In the top text box enter:
0000,0000
OK
That should give you 0321,0322
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
M
Mark Graesser
Hi lila
Or if your numbers aren't being used as numbers (you won't be doing any math on them) you could format the cells as text
Format>Cells>Number>Tex
Or another quick way is to type an apostrophe in front of the value. The ' won't show up in the cell, but it will prevent Excel from applying any number formatting
God Luck
Mark Graesse
[email protected]
Boston M
----- lila wrote: ----
Hi, Norman
I am brand new to this so I dont really know. I just opened excell and put a formula = in cells and typed my info and the zero's are just disapering. exam. 0321,0322 after I go to next cell it looks like this 321,0322. I put a space after the comma and it worked zero stayed but I dont want to put a space to mech info in one cell to be puting spaces
What am I doing wrong
thanks
lila
Or if your numbers aren't being used as numbers (you won't be doing any math on them) you could format the cells as text
Format>Cells>Number>Tex
Or another quick way is to type an apostrophe in front of the value. The ' won't show up in the cell, but it will prevent Excel from applying any number formatting
God Luck
Mark Graesse
[email protected]
Boston M
----- lila wrote: ----
Hi, Norman
I am brand new to this so I dont really know. I just opened excell and put a formula = in cells and typed my info and the zero's are just disapering. exam. 0321,0322 after I go to next cell it looks like this 321,0322. I put a space after the comma and it worked zero stayed but I dont want to put a space to mech info in one cell to be puting spaces
What am I doing wrong
thanks
lila
C
CLR
You can enter number strings in a cell having leading zeroz by preceeding
the string with an apostrophe ('), which turns the entry into
TEXT..........or you can just pre-format the cell to be TEXT and the leading
zeroz will hold...........
Vaya con Dios,
Chuck, CABGx3
the string with an apostrophe ('), which turns the entry into
TEXT..........or you can just pre-format the cell to be TEXT and the leading
zeroz will hold...........
Vaya con Dios,
Chuck, CABGx3
THE ZERO DISAPERS AND A COMMA APEARS I DONT WANT THIS???LILA said:HOW DO I PUT A ZERO IN FRONT OF MY NUMBERS EVERY TIME I GO TO NEXT CELL