Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounded numbers do not add properly. | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Validating random numbers | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions |