Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number formatting
I have a number in Excel 475640.00 and I need it to be 4756.40. However the
entire column of numbers does not have the same amount of charcters. For example in this column is also 61300 which should be 613.00 and 4567829.00 which should be 45678.29 I tried text fixed with but that didn't work because of the different amount of charcters in each number. How can I change this format so that all the numbers are correct? |
#2
|
|||
|
|||
Would dividing it by 100 give you the same outcome?
Then =A1/100 and copy across/down should do "KP Lost in Formatting" <KP Lost in wrote in message ... I have a number in Excel 475640.00 and I need it to be 4756.40. However the entire column of numbers does not have the same amount of charcters. For example in this column is also 61300 which should be 613.00 and 4567829.00 which should be 45678.29 I tried text fixed with but that didn't work because of the different amount of charcters in each number. How can I change this format so that all the numbers are correct? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formatting a number | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |