scientific format problem
Posted by Lou on December 05, 2001 3:51 PM
While working as a data inputter from home, i have come across a problem i can't work out. Column A is formatted to General and is used for inputting 'part numbers containing text, numbers, slashes and dashes. Every time i input a 12 digit, numeric number, it converts itself to scientific format. When i go into formatting, the example display for General, Text and Numeric all display a scientific format. The only way round it i can find is to format to Custom, 0. Why is the data converting when its been set to a certain format?