NUMBERS

[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

 

[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'

 

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

 

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

 

[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

 

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

 

[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
(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

 

[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

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