Large interval of currency numbers in Excel

The solution steps are as follows:

1. first select the cell where you want to insert currency symbol and number, then right-click and select set cell format in the pop-up box

2. select the number in setting cell format, and then select custom options

3. select 0.00 in the customization, then add the currency symbol in the input box, and click OK. The currency symbol will be added automatically after entering the number in the cell

   

bus route: No.31 → no.t60, the whole journey is about 21.8km

1. Walk about 3.9km from China Power Valley Independent Innovation Park to Majiahe station

2. Take No.31, pass through 2 stations, reach Taishan Square Station

3. Walk about 200m, reach shennongcheng station

4. Take no.t60, pass 4 stations, reach railway station

5. Walk about 100m, Arrive at Zhuzhou Station

or

31 road → T28 road 21.9km

31 road → 108 road 23.3km