Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 59
  • 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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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