• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Excel - Number in Cell Will Not Behave

Hi, I am creating a very simple Excel file for a user to populate with part numbers that I have attached to a Crystal report. We are on;ly using column A with no formulas or calculations. This is just a flat file for them to use to get data back just on the part numbers that they want to see. I have populated several cells for testing and found I have one rogue. When entering the data all of my entries justify to the left except this one number, it justifies to the right. This is no big deal except it tells me something must be different about this part number. If I go to the Crystal report that is using this file to look up the part numbers and I browse this data field I can see all the part numbers that I have entered except this one. This is an example of the list:

2722M69G01
4013770-389
5318216-01
5318217-01
5319098-01
7010102H03
704977-3
7083M57G02
7086M33G01
710181-2CSI
749059-1
763904
1725911

It is the last one in this list that is the trouble maker, 1725911. I have tried formatting the cells to number, text and general with the same frustrating results. Any help with this would be appreciated.

Thank you
0
daskas27
Asked:
daskas27
  • 3
  • 3
1 Solution
 
Ejgil HedegaardCommented:
General format means that text are left justified, and numbers are right.
The last 2 on the list are numbers, the others are text.
To force a number to be a text, add a ' in front of the number, so the last will be '1725911
0
 
daskas27Author Commented:
That is the strange thing. The next to the last one, which is a number, shows up just fine.
0
 
Ejgil HedegaardCommented:
Please upload a sample file.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
daskas27Author Commented:
Oops, my mistake. So I have to have the user add the ' whenever it is a "number"?
0
 
Ejgil HedegaardCommented:
If you format the column as text before entering, numbers are inserted as text.
0
 
daskas27Author Commented:
Thank you!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now