numbers being rounded
 

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

numbers being rounded
 

intemporal Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=498076