If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to make excel not round real numbers when making a histogram? | Leedawg | Charts and Charting | 1 | September 21st, 2005 07:36 PM |
Count comma separated numbers, numbers in a range with dash, not t | Mahendra | General Discussion | 0 | August 8th, 2005 05:56 PM |
ROUNDED NUMBERS IN FORMULA'S | BING1080 | General Discussion | 3 | June 22nd, 2005 11:09 AM |
How do I sort letters before numbers in Excel? | RiverGirl | General Discussion | 4 | May 27th, 2005 04:09 PM |
Checking Winning Numbers in the Lottery. | Ann | General Discussion | 4 | May 18th, 2005 10:55 AM |