number format

K

K

I have a text file that was imported into excel. There
are no decimal points in the numbers but I would like to
have decimal points. However, when I try to format the
cell, it acts as if there are no cents and adds two zeros
to the number.

Text format: 5120
numercial fomatting in excel: 5,120.00
The number should be $51.20

Could you please offer a suggestion?
 
F

Frank Kabel

Hi
you have to divide the numbers with 100 first. Try:
- put 100 in an empty cell
- select your imported data
- goto 'Edit - Paste Special' and choose 'Divide'
 

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

formula for decimal point 4
Decimal point in general format 1
How specify number format of cell value in concatenate function? 1
Convert number to text as displayed 3
Format Number Outlook Merge 1
Excel Excel 2007 won't stop rounding down my formula results! 5
15+ digit numbers 3
Customer Number Format 1

Top