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???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading Zeros; How to Keep ? 2
Displaying zeros in cells 2
Importing from a Notepad file 3
coutif problem 3
Id instead of names...? 2
zeros are being added to my numbers 2
How to display zeros at the beginning of a number? 5
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top