Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing 1234.00- to -1234.00 automatically
Everyday I have to copy and paste data from a program to an excel
spreadsheet. Positive numbers come in fine, negative numbers don't. They align to the left of the cell with the negative sign to the right of the numbers. Currently I: F2, backspace, home, put in the - sign and enter to the next cell where I repeat this approximately 80 times. I have tried setting up a macro, a scenerio, and a what if function, but with no luck on any of them. The macro was my best guess, but it saves the number along with the steps, so everyday the numbers revert back to the ones saved in the macro not what they should be. Does anyone have a solution for quickly changing the format of these numbers after they are pasted in? -- Thank you, Lisa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating and changing cells automatically | Excel Discussion (Misc queries) | |||
Automatically Changing Functions | Excel Discussion (Misc queries) | |||
Need to stop formuls from automatically changing | Excel Discussion (Misc queries) | |||
Automatically changing colors | Excel Discussion (Misc queries) | |||
Excel Changing Numbers Automatically | Excel Discussion (Misc queries) |