NUMBERS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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'
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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)
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
(e-mail address removed)
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
 
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


LILA said:
HOW DO I PUT A ZERO IN FRONT OF MY NUMBERS EVERY TIME I GO TO NEXT CELL
Click to expand...
THE ZERO DISAPERS AND A COMMA APEARS I DONT WANT THIS???
 
Back
Top