Change numbers into money
The number in excel is changed into currency "#" format mostly e to the use of other formats, which can be changed back to numerical value or conventional. The specific steps are as follows:
required materials: Excel
First, open the excel file and select the number cell in currency format
The reason for this phenomenon is that there is a problem in the setting. The specific solutions are as follows:
1. First, create a new excel document
After selecting this column of cells, set the cell format
1. If the number is pasted, please select the value "123" in
"paste special"
2. If the number is manually entered, please right-click the cell containing the number, Set the cell format, select "general"
or select the cell containing numbers, and then click Ctrl +! Shortcut key, you can quickly open the cell Format dialog box, select "general" or other data types you need.
word,
but you can use macros. I'm not good at macros. Please try to extract other people's macros; You can use the following macro. You need to specify the shortcut key
sub temp()
selection. Text = format (selection. Text, & quot; # #, # # 00") < br />
End Sub ' Do you want to name it by yourself?
-
the cursor is in front of the number and the point is inserted
-
select the currency symbol, such as & #;, Then click the insert button
-
just add. 00 after the number
let's see what others say.
2, Double click it
3. Select workbook from the left drop-down list and open on the right
4. Add the code below < / OL >
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -; If it is not the first table, change 1 to & quot; Change the table name, such as sheets (1) to sheets (& quot; Table name & quot;)< br /> cl = Sheets(1).UsedRange.Find(" Count", , 1).Column
px = Sheets(1).Cells(1, cl).Address
ra = Split(px, "$& quot;)( 1)
Sheets(1).Range(ra & & quot;:& quot; & amp; ra).NumberFormatLocal = "$#,## 0;-$#,## 0"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -; Table name & quot;, For example, change sheets (1) to sheets (& quot; Table name & quot;)