Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add 2 decimal places
I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that? |
#2
|
|||
|
|||
Bill M. wrote:
I have a column of numbers which were imported as text and need to have the last two places changed to decimals. How do I do that? Type in the number 10 in a spare cell. highlight it, select "copy" then select the column you wish to change, right-click on it, select "paste Special" and under "Operation" choose divide. HTH -- Registered Linux User no 240308 Just waiting for Broadband to complete the conversion!(3 weeks and counting!) gordonATgbpcomputingDOTcoDOTuk to email me remove the obvious! |
#3
|
|||
|
|||
Do you still want them to be text?
If not =--(A1)/100 if text =TEXT(--(A2)/100,"@") Regards, Peo Sjoblom "Bill M." wrote: I have a column of numbers which were imported as text and need to have the last two places changed to decimals. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Significant figures (not decimal places) | Excel Worksheet Functions | |||
Decimal places in Excel 2003 | Excel Worksheet Functions |