Cell Format

P

pm hudson

When I key numbers into a cell, the format returned is not what is keyed
in....and no matter what format I change it too, it stays the same. HELP!!
 
P

Pete_UK

In what way do they vary? Give a few examples. Do you have a decimal
point inserted? Does the number become a date? Are the numbers changed
completely?

Pete
 
S

Sasa Stankovic

What do you mean - When I key numbers... and no matter what format I change
it too, it stays the same.

I do not understand the problem!?
 
R

Rick Rothstein \(MVP - VB\)

When I key numbers into a cell, the format returned is not
what is keyed in....and no matter what format I change it
too, it stays the same. HELP!!
Click to expand...

It would really help if you told us what numbers you were keying in, what
"format" you were seeing for it and what "format" you were expecting to see.
Otherwise, we cannot know what your problem is.

Rick
 
P

pm hudson

For example....when I key 109 into a cell, it returns 0.00109. All numbers
are converted in this way. It adds 0.00 to each number entered. Even when
changing the formatting, it still returns the same number.
 
Top