Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace in a currency column
ALL commas and replace them with periods.
Anyone know how to do that ? -- AMH |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace in a currency column
If the value in the cell is a number formatted as currency, either change
Windows regional settings (under Control Panel), or go to ToolsOptionsInternational uncheck the option to use System separators and change the comma to a period If the value in the cell is a text representation of a currency amount, select all the currency amounts then press Ctrl-H, enter a comma in the search box and a period in the replace box. "AMH" wrote: ALL commas and replace them with periods. Anyone know how to do that ? -- AMH |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace in a currency column
your question is not clear. however I try the following if I could understand properly what your requirement is. press Ctrl+H Find what: enter here any value you want to replace (say ,) Replace with: enter here value you want to replace with. press Replace All AMH Wrote: ALL commas and replace them with periods. Anyone know how to do that ? -- AMH -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=568303 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions |