Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied number eg 1234- to display as (1234.00) in red in Excel
On a previous pc where Excel 97 was upgraded to 2003 I was able to copy
numbers with a negative behind it eg 1564- from a mainframe application and paste it into Excel and it would automatically format it as a negative eg red (1564.00). I have just got a new pc (with a clean install of 2003) and this no longer works. It now pastes the original number eg 1564- as 1564-, i.e. it no longer recognises or formats it as a negative number. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied number eg 1234- to display as (1234.00) in red in Excel
Data Text to Columns. Next Next Finish
-- David Biddulph "dallas" wrote in message ... On a previous pc where Excel 97 was upgraded to 2003 I was able to copy numbers with a negative behind it eg 1564- from a mainframe application and paste it into Excel and it would automatically format it as a negative eg red (1564.00). I have just got a new pc (with a clean install of 2003) and this no longer works. It now pastes the original number eg 1564- as 1564-, i.e. it no longer recognises or formats it as a negative number. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied number eg 1234- to display as (1234.00) in red in Excel
Thanks, this worked, obviously it's bringing the value in as text. It's a
solution for after the fact but since this is an ongoing (daily) procedure I was hoping to find a solution that didn't require additional formatting every time data was pasted, but this may be the best that can be done. "David Biddulph" wrote: Data Text to Columns. Next Next Finish -- David Biddulph "dallas" wrote in message ... On a previous pc where Excel 97 was upgraded to 2003 I was able to copy numbers with a negative behind it eg 1564- from a mainframe application and paste it into Excel and it would automatically format it as a negative eg red (1564.00). I have just got a new pc (with a clean install of 2003) and this no longer works. It now pastes the original number eg 1564- as 1564-, i.e. it no longer recognises or formats it as a negative number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing 123456 to $1234.56 | Excel Worksheet Functions | |||
Changing 1234.00- to -1234.00 automatically | Excel Discussion (Misc queries) | |||
how to change (555)123-1234 to 5551231234 | Excel Discussion (Misc queries) | |||
how to change (555)123-1234 to 5551231234 | Excel Discussion (Misc queries) | |||
Why when I enter 1234 do I see 12.34 in Excel ? | Excel Discussion (Misc queries) |