General Format to Custom format problem

  • Thread starter Thread starter KELC-F/A
  • Start date Start date
K

KELC-F/A

I am working with a PeopleSoft query exported into Excel. The query
generates a number in General format: 10232427348734667 displaying in the
cell to left side as a text field. I am trying to create custom format to
display as
102-3242734-8734667 showing three numbers-dash-seven numbers-dash-seven
numbers. So far I used Data-Text to numbers>Delimited>Tab>General. Then
selected custom format trying different combinations. Everything I try
results in the last two numbers displaying as 00 Example:
102-3242734-8734600-Any suggestions?
 
Excel only keeps track of 15 significant digits. After those 15, you'll see
0's.

You could bring your data in as text, but then the format|cells|number tab
formatting won't work--number formats work on numbers--not text.

After the data is brought in as text, you could use a helper cell with a formula
to make it look pretty:

=LEFT(A1,3)&"-"&MID(A1,4,7)&"-"&RIGHT(A1,7)
 
Back
Top