| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to format numbers that are already entered?
I copied a huge spreadsheet. I need to change the numbers in one column to
reflect 2 decimal places. But the decimal place must go within the numbers already there and not add zeroes then the decimal. I have tried to customize the cell but it is not coming out the way i want it to be. For example 356322 should read 3,563.22. Please help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same. | Excel Discussion (Misc queries) | |||
| Numbers aren't changing with new format why? | Excel Discussion (Misc queries) | |||
| Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
Threaded Mode
