Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Data in Excel Spreadsheet
How do I refresh data in MS-Excel 2003 w/o manually pressing F2 and enter?
The issue is I have a coulnmn that was brought in from an external data source as text format, when the column should have been accounting format or currency format. When I re-format the column to accounting or currency, the amounts are not refreshed to reflect the new format until I manually touch the cell by pressing F2 and enter. This would be OK, except that I have 2500 rows of information to refresh. Is there a way to have the column automatically refresh? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Data in Excel Spreadsheet
Hello Muzickdoc,
I assume the data has the little tag in the corner to indicate a formatting issue? If so, select all the data, click the first cell then shift control down arrow. You should see a yellow box appear to the left of the list. In it is a conversion from text to numbers option. That should do it. Good luck "muzickdoc" wrote: How do I refresh data in MS-Excel 2003 w/o manually pressing F2 and enter? The issue is I have a coulnmn that was brought in from an external data source as text format, when the column should have been accounting format or currency format. When I re-format the column to accounting or currency, the amounts are not refreshed to reflect the new format until I manually touch the cell by pressing F2 and enter. This would be OK, except that I have 2500 rows of information to refresh. Is there a way to have the column automatically refresh? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Data in Excel Spreadsheet
What's up, Doc?
This happens to me often enough that I wrote some code to handle it. Highlight the range of data, then run this code. Enjoy the weekend! Sub Selected_Range_Format() Dim rCell As Range Dim TrueVal As Variant For Each rCell In Selection.Cells TrueVal = Trim(rCell.Value) rCell.ClearContents rCell.NumberFormat = "$#,##0.00" rCell.Value = TrueVal Next rCell End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import data from a closed Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Excel will not automatically refresh external data on open | Excel Discussion (Misc queries) | |||
Refresh data from an Excel sheet | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |