I'm just trying to guess what exactly you want to achieve and if i got
that right - i think you want to apply format 'General' to a specific
range of cells and want the values in those cells to show up according
to the 'General' format.
So, in that case you could have something like this:

Sub FormatMyRange()

Dim oneCell As Range
Dim myRange As Range

Set myRange = Range("A1", "A8")'This is your range to be formated
- amend as necessary
For Each oneCell In myRange
With oneCell
.NumberFormat = "General"'Sets the cell's format to
General
.Value = .Value'Reenters the cell's value into itself so
that it would asume the 'new' format
End With
Next oneCell

End Sub


On 4 Dec, 12:37, Jan S wrote:
I am just learning how to use Macros and I have a process I do quite a bit
that I would like to have a macro created for. *I use copy - paste
special/multiply often when needing to change number formats. *What I would
like to do is to create a macro that will multiply a cell or reange of cells
by 1 (formateed as a number with no decimals or even just as general, how can
I accomplish this?