software

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


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

Format the cells for your codes as TEXT.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=498076