numbers being rounded

I

intemporal

a chart that i am making has two kinds of numbers, one set is prices and
another set is the codes that our system reads to apply the prices. the
problem i am having has to do with the codes. Some codes have to have a .0
(as in 678.0) and some have to start with a zero (as in 054). but as soon as
i click out of the cell the numbers are rounded to 687 and 54. but those
zeros are important to our system. i tried to mess with the decimal places
but it just didnt help. Thank you
 
B

BenjieLop

intemporal said:
a chart that i am making has two kinds of numbers, one set is prices
and
another set is the codes that our system reads to apply the prices.
the
problem i am having has to do with the codes. Some codes have to have
a .0
(as in 678.0) and some have to start with a zero (as in 054). but as
soon as
i click out of the cell the numbers are rounded to 687 and 54. but
those
zeros are important to our system. i tried to mess with the decimal
places
but it just didnt help. Thank you

Format the cells for your codes as TEXT.

Regards.
 

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

Top