Add Signed Us Currency with airSlate SignNow

Insert currency log

[Music] [Music] hello everyone how are you doing this is MD tag here another quick tutorial today I'm going to show you guys how to create a currency symbol and add decimals to values in Microsoft Excel so appreciate forward tutorial and it's a couple little tricks that I figure should be kind of combined into one subject so number one let's say we have this excel file here and we have these numbers not only do we want to add a dollar sign to all them at the same time rather than just going one at a time but we also want to add cents so dot zero zero to the end or something like that so pretty simple I know in some cases the cells might have already been formatted where if you're try and insert a dollar sign and won't let you so this tutorial will also be a six for that so depending on what we're trying to do if we have certain cells we're trying to do this for you can just highlight over them if we're trying to do this for the entire column you can just right click on the top letter and this will select all the cells in that column and then you want to go down to where it says format cells and left-click on it now that we're in the format cells window we want to head over to the number 10 at the top left the third option down should say currency left click on that so now it should say decimal places if you want to include cents make it two and then the symbol set it's a dollar sign if you one if you have other currencies if you do that as well and once you're done doing that you can just left click on OK and we see that all of our values have been turned and converted into currencies so keep in mind like I did a little example here this was 2.5 B for Microsoft Excel did not add an extra zero on top of that to the thousands place value so it appears as it should two dollars and fifty cents and all of them should appear in the correct format so I hope you guys enjoyed this brief tutorial and I will catch you in the next video goodbye