| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a decimal to numbers
I am importing a list of dollar amounts into excel, and they do not have decimals to seperate the cents amounts. if there is no change then it will put 00. I cant figure out how to add them. Importing 14000 4005 26700 14000 Needs 140.00 40.05 267.00 140.00 Thanks -- rennersc ------------------------------------------------------------------------ rennersc's Profile: http://www.excelforum.com/member.php...o&userid=37345 View this thread: http://www.excelforum.com/showthread...hreadid=570453 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a decimal to numbers
14000 / 100 = 140.00 format as numbers and 2 decimal plases
"rennersc" skrev: I am importing a list of dollar amounts into excel, and they do not have decimals to seperate the cents amounts. if there is no change then it will put 00. I cant figure out how to add them. Importing 14000 4005 26700 14000 Needs 140.00 40.05 267.00 140.00 Thanks -- rennersc ------------------------------------------------------------------------ rennersc's Profile: http://www.excelforum.com/member.php...o&userid=37345 View this thread: http://www.excelforum.com/showthread...hreadid=570453 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a decimal to numbers
Enter 100 in an unused cell then copy it. Highlight the imported data and
select Paste Special Divide. Then format the imported data as number with two decimal places -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "rennersc" wrote in message ... I am importing a list of dollar amounts into excel, and they do not have decimals to seperate the cents amounts. if there is no change then it will put 00. I cant figure out how to add them. Importing 14000 4005 26700 14000 Needs 140.00 40.05 267.00 140.00 Thanks -- rennersc ------------------------------------------------------------------------ rennersc's Profile: http://www.excelforum.com/member.php...o&userid=37345 View this thread: http://www.excelforum.com/showthread...hreadid=570453 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a decimal to numbers
I never thought of that.. Thanks! excelent Wrote: 14000 / 100 = 140.00 format as numbers and 2 decimal plases "rennersc" skrev: I am importing a list of dollar amounts into excel, and they do not have decimals to seperate the cents amounts. if there is no change then it will put 00. I cant figure out how to add them. Importing 14000 4005 26700 14000 Needs 140.00 40.05 267.00 140.00 Thanks -- rennersc ------------------------------------------------------------------------ rennersc's Profile: http://www.excelforum.com/member.php...o&userid=37345 View this thread: http://www.excelforum.com/showthread...hreadid=570453 -- rennersc ------------------------------------------------------------------------ rennersc's Profile: http://www.excelforum.com/member.php...o&userid=37345 View this thread: http://www.excelforum.com/showthread...hreadid=570453 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too Many Numbers After The Decimal | Excel Discussion (Misc queries) | |||
| Adding numbers from a list over a specific value | Excel Discussion (Misc queries) | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| How do I delete multiple cells with decimal, not whole, numbers? | Excel Worksheet Functions | |||
| sorting numbers more than one decimal | Excel Worksheet Functions | |||
Linear Mode
