| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Telephone number format | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
