help: create a custom number format

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3136050%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3Ehelp%3A%20create%20a%20custom%20number%20format%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3136050%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20am%20trying%20to%20create%20one%2C%20but%20when%20I%20do%20this%3A%20If%20I%20want%20to%20add%20dollars%20or%20euros%20it%20does%20not%20let%20me%2C%20perhaps%20I%20am%20going%20something%20wrong%C2%BF%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3COL%3E%3CLI%3E%3CP%20class%3D%22%5C%26quot%3B%5C%26quot%3B%22%3ESelect%26nbsp%3B%3CSTRONG%3ECustom%26lt%3B%5C%2FSTRONG%26gt%3B.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CSTRONG%3E%3CP%20class%3D%22%5C%26quot%3B%5C%26quot%3B%22%3EIn%20the%26nbsp%3B%3CSTRONG%3EType%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Blist%2C%20select%20an%20existing%20format%2C%20or%20type%20a%20new%20one%20in%20the%20box.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3E%3CSTRONG%3E%3CP%3ETo%20add%20text%20to%20your%20number%20format%3A%26lt%3B%5C%2FP%26gt%3B%3CUL%3E%3CLI%3E%3CP%3EType%20what%20you%20want%20in%20quotation%20marks.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EAdd%20a%20space%20to%20separate%20the%20number%20and%20text.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%26lt%3B%5C%2FUL%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%26lt%3B%5C%2FOL%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3136050%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FP%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

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¿? 

 

  1. Select Custom.

  2. In the Type list, select an existing format, or type a new one in the box.

  3. 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

@Natalia_Farr 

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.

image.png

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.

 

@Sergei Baklan 

Hi Natalia, could you re-send the link please? I get an error when I try to open it
Thank you!
let me know if you need anything more
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?
Hi, can you share some screenshot of the formula you are using please
=VLOOKUP(A9,A4:B7,2,FALSE)

@Natalia_Farr I am typing to you from Peru and my Excel is configured in Spanish, instead of BUSCARV it would be VLOOKUP.

 

Captura.JPG

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

Excuse me, do you see any image in my previous answer? I don't see it, but it appears to me that there is an image in my response.
The #N/A Error appears when the formula does not find what you was asked for. In VLOOKUP it would be that it doesn't find it in the lookup array
OK I have tried again and all good now
No, I dont see any image. Sorry
HI again

I have some doubts now but regarding tables. I dont see the design tab in my excel: so I can go to the total row, where can I find it? However, the other way to sum up the total of the column it does work out
Hello, did you solve it?

Or in any case, you can share me some screenshot.

any news with this? @Natalia_Farr 

any news with this?