Hi Jack

AFAIK there's no real benefit to entering numbers as text in the first
place - unless they aren't really numbers (e.g. phone numbers with a leading
0 - if you entered it directly as a number the 0 will be removed).

But if you're numbers are really numbers (e.g. 1.11) i would enter them
directly as numbers. Secondly, you didn't say HOW you were converting from
text to numbers - so i don't really know why the rounding is occuring - it
might be a display thing (click on the increase decimal icon on the toolbar
to see if the other decimals come back) or let us know how you're converting
them and this might help solve the problem

Cheers
JulieD

"Jack" wrote in message
...
Can anyone help? When I am converting text to numbers in excel,
occasionally
some numbers will roundoff, especially if I am converting a number of
cells
at one time. For example I may be converting the text value of 1.11 to a
number, and it rounds it to 1.1. Why is it doing this?

Also, as I am a novice, what the purpose of entering numbers as text to
begin with?
--
Thanks - Jack