number format
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? |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com