General Format to Custom format problem


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?
 
Ad

Advertisements

D

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number Format for text 8
Changin cell format and view 3
custom number format 1
custom inputs 1
Auto Cell Format Change from General to Custom Date 1
general format 2
Excel 2002; cell format confuses Custom and Special 2
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2

Top