How to avoid opening report in currency format

1.

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

2. Select all the tables, and then Ctrl + Shift + ~ should be OK. The last symbol is the wave sign. Try it

3. Please set the properties of each cell, right-click the cell, select "set cell format", and select the required classification on "number". If you're not wrong, your current cell classification is "currency" in the third attribute.

4. If you mean that a cell in regular format will change to currency format after entering a number, please try the operation:
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.

5. That's the problem of cell setting. Just set it to digital type

6. This is the problem of setting up. Proceed as follows; After opening excel, right click Select; Set cell format --
select; Number selection; General - click OK to restore.

7. Click the cell with symbol, right-click, select custom in the number option, and click "delete" at the bottom of the box

8. No, regular numbers are going to be like this
is your computer a local language
look at the settings

9. Currency number format is only applicable when the data in excel2010 cell is currency number. The specified currency symbol will be added to the cell set to currency number format. The steps to format currency numbers in Excel 2010 are as follows: http://jingyan..com/article/359911f516953d57fe0306e1.html

10. Bus stop - Longgang Central Hospital Station
bus: No. 309; 351 road; 353 road; 380A line; 802 channel; 810 road; 811 road; 839 road; 862 road; M275 road; M276 road; M279 road; M280 road; M296 road; M307 road; M308 road; M316 road; M386 road; Shenhui line 1

if it's not too far away, take a seat in Shuanglong, and then go north for a section