| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
numbers change to text
I have a row of formulas that yield a percentage. These formulas reference % values on another work sheet I have the following Macro that copies these values to another row that is formatted % Private Sub CommandButton5_Click() 'Copies Calculated MI% to Actual MI% Range("AB41:AF41").Select Selection.Copy Range("AB40").Select Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range("AB40").Select End Sub The copy results in numbers formatted as text What am I doing wrong? oldjay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Change Numbers to Text. ie $1.00 = one dollar | New Users to Excel | |||
| Change text to numbers | Excel Discussion (Misc queries) | |||
| Why won't my cells change from Text to % or Numbers | Excel Discussion (Misc queries) | |||
| the numbers are always in text and i cant seem to change them??? | Excel Worksheet Functions | |||
| change numbers to text | Excel Worksheet Functions | |||
Threaded Mode
