Forum Discussion
help: create a custom number format
I am trying to create one, but when I do this: If I want to add dollars or euros it does not let me, perhaps I am going something wrong¿?
Select Custom.
In the Type list, select an existing format, or type a new one in the box.
To add text to your number format:
Type what you want in quotation marks.
Add a space to separate the number and text.
19 Replies
In general you don't need custom format for the currency. You may apply currency format from ribbon; or Ctrl+1 on cell and select proper one.
- Hi again:
I am now in the formulas & functions section. I am trying the VLOOKUP and when I do this it gives me error:
Meat Amount
Beef 100
Chicken 50
Pork 30
Fish 40
Chicken #N/A
can you try it?Natalia_Farr I am typing to you from Peru and my Excel is configured in Spanish, instead of BUSCARV it would be VLOOKUP.
I don't see error in the formula you comment. It may be that the word you are looking for is not as it is in the search matrix, make sure there are no other spaces in your word you are looking for and in your matrix
ok thank you Sergei. I am doing this training https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb,
if I need any more help I will tell you.
- Hi Natalia, could you re-send the link please? I get an error when I try to open it
