| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move the negaive symbol from the right to the left side of a numbe
I have a situation whereby I am cutting and pasting a large volume of
negative values into Excel from another operating system and the the negative values are on the right side of the number which Excel 2003 does not recognise as a number. Is there a setting in Excel that will recognise the negative if the character is on the right. Or, is there a macro/vba to move the negative from the right eg. 500.00- to the left eg. -500.00. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need me first row to stay on left side as I move across thepage | Excel Discussion (Misc queries) | |||
| How do I Move column A, B, etc. to left side. | New Users to Excel | |||
| move y-axis labels on column chart from left to right side | Charts and Charting in Excel | |||
| y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
| In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions | |||
Threaded Mode
