Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change quantities entered as dollars to $K
There's got to be a quick and easy way to do this but I'm frazzled and can't
find it. I am rolling up several worksheets in which people were to have entered budget info in $K (dollars in thousands) but some entered in plain dollars. I need to be able to quickly convert something entered as 14,500 to 14.5. I'm using Excel2002 and the cells are formatted as number with zero decimal places. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem calculating percent change | Excel Worksheet Functions | |||
Change source according to data entered in a template. | Charts and Charting in Excel | |||
Change value in cell | Excel Discussion (Misc queries) | |||
Currency to Text | Excel Worksheet Functions | |||
Numbers entered change to 0 | Excel Discussion (Misc queries) |