numbers being rounded

Originally Posted by 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

Format the cells for your codes as TEXT.

Regards.