Excel Help and Problems

[unavailable]

will it not print the background?

[Yisroel Tech]

The real way to do this would be to insert the picture in the Header (with Text Wrap set to Behind Text) and then print with a code like the one here https://www.extendoffice.com/documents/word/5453-word-print-without-header-and-footer.html

[Definitions]

will it not print the background?

It will if you keep it there. The idea was to set up the text boxes on top of the image where you want it to be filled in. Then just delete the image and use it as a template. Basically the same thing as what yo ssi was saying

[unavailable]

what I did until now, was, I wrote the words in the place I thought they belonged. Then I printed it, and adjusted where needed, after a few tries it was good.
I just thought that with todays' software, there is prob a better ore effective way, looks like there isn't.

[yoruel]

Withiut VBA, can I Auto complete text in a drop down list cell.
I used data validation to create my drop down list.
We have over 300 items to enter.

[skyguy918]

Withiut VBA, can I Auto complete text in a drop down list cell.
I used data validation to create my drop down list.
We have over 300 items to enter.

Try this:
https://superuser.com/questions/1419626/how-can-i-add-autocomplete-to-an-excel-drop-down-validation

[yoruel]

Thank you.
Problem is need to always create a new combo box

[yitzf]

Withiut VBA, can I Auto complete text in a drop down list cell.
I used data validation to create my drop down list.
We have over 300 items to enter.

Just announced 2 days ago. They're rolling it out slowly.
https://techcommunity.microsoft.com/t5/excel-blog/speed-up-data-entry-and-validation-with-autocomplete-for/ba-p/3072083

[Yisroel Tech]

Just announced 2 days ago. They're rolling it out slowly.
https://techcommunity.microsoft.com/t5/excel-blog/speed-up-data-entry-and-validation-with-autocomplete-for/ba-p/3072083

In the meantime, try Google Sheets...

[ushdadude]

Excel saved a list of tracking numbers in scientific notation. when i convert back to a regular number the last 6 digits are all 000000. Anyway to get that data back?

[Definitions]

Excel saved a list of tracking numbers in scientific notation. when i convert back to a regular number the last 6 digits are all 000000. Anyway to get that data back?

If you still have the original before you converted it change it to text.

I wonder if Ctrl z would work too

[ushdadude]

If you still have the original before you converted it change it to text.

I wonder if Ctrl z would work too

i don't have access to it but BH when i opened it sheets, the data was there

[JM]

i don't have access to it but BH when i opened it sheets, the data was there

In the future if you put a single apostrophe (') in front of a tracking number or a zip or anything with a potential leading 0, it'll prevent excel from messing with the number

[ushdadude]

In the future if you put a single apostrophe (') in front of a tracking number or a zip or anything with a potential leading 0, it'll prevent excel from messing with the number

Thanks,
Vegetables that's what I do but this was a long list of numbers I imported

[AsherO]

Thanks,
Vegetables that's what I do but this was a long list of numbers I imported

Paste values into columns formatted as text.

[jose34]

What would be the formulta if I wanted to Excel to:
I have data coming into Excel from another cell and I wanted to add or subtract based on that number.

For example: if the incoming number is below 5 I want Excel to subtract the incoming number by 5 (for example incoming number is 2 so Excel should subtract 5-2), if the incoming number is above 5 ( for example incoming number is 7 so Excel should add 5+7) I want it to add the incoming number.

[JuryDuty]

What would be the formulta if I wanted to Excel to:
I have data coming into Excel from another cell and I wanted to add or subtract based on that number.

For example: if the incoming number is below 5 I want Excel to subtract the incoming number by 5 (for example incoming number is 2 so Excel should subtract 5-2), if the incoming number is above 5 ( for example incoming number is 7 so Excel should add 5+7) I want it to add the incoming number.

You'd have to specify what you want if it equals 5. But =if(a2>5,b2-a2,b2+a2) something like that. A2 would be the incoming number, b2 is the number you would be adding or subtracting it from

[JuryDuty]

Question: recently, I've been using flash fill, and the equation fills out correctly but the number appears as a copy of the first cell. If I save the file, the numbers are corrected, matching the equation. Any idea what's happening?

[skyguy918]

Question: recently, I've been using flash fill, and the equation fills out correctly but the number appears as a copy of the first cell. If I save the file, the numbers are corrected, matching the equation. Any idea what's happening?

You probably have calc on manual, and when you save it recalculates.

[hocker]

If anyone can help me with a simple conditional formatting I'd really appreciate it. I'm trying to compare two lists and highlight cells in column 1 that also appear in the list on sheet 2. Tried google and for some reason it is not working.