Feb 08 2022 03:38 AM
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.
Feb 08 2022 05:03 AM
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.
Feb 08 2022 08:48 AM
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.
Feb 08 2022 08:53 AM
Feb 08 2022 08:55 AM
Feb 08 2022 09:35 AM
Feb 08 2022 09:47 AM
Feb 08 2022 09:54 AM
@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
Feb 08 2022 09:56 AM
Feb 08 2022 10:00 AM
Feb 09 2022 12:28 AM
Feb 13 2022 01:48 AM
Feb 15 2022 06:22 AM