unwanted functions

Question

how do I remove functions

Answer 1

Re: enter data and make Excel leave it alone

If the above is what you need, then an altered entry can be

fixed by re-entering your data and using an apostrophe as the

first character followed by your data...

'1/2/3 will appear as 1/2/3 instead of 01/02/2003

The apostrophe does not appear in the cell, however you can

see it in the Formula bar.

The above works for all types of entries.

'---
Nothing Left to Lose

Answer 2

What sort of "database" do you want to create?

What information do you want to save in it?

What do you want to do with the information.

.

Excel is OK for relatively small, simple databases.

.

You can define "relationships" between "tables" in Excel using PowerPivot

Data Model / Power Pivot - Overview and Learning

https://support.microsoft.com/en-us/office/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013

Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.

.

Create a relationship between tables in Excel

https://support.microsoft.com/en-us/office/create-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3

Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table. Then you can create Power View sheets and build PivotTables and other reports with fields from each table, even when the tables are from different sources. For example, if you have customer sales data, you might want to import and relate time intelligence data to analyze sales patterns by year and month.

.

Answer 3

Thankyou

I just want to create data bases

No formulas no functions

Without getting "functions isn't valid" or my entries being replaced with numbers or letters when I try to change input

Q½ ??

I am not sure what the diagrams are or the Q1\2 is

I just to be able to make columns with say names or numbers

1st column first names 2nd column last name and do simple sorts or with numbers sums

That's my level of expertise LOL

That's what I know how to do

When it gets to be formulas & functions it's way over my head or desire of learning

I just want them gone remove cleared deleted- whatever

Answer 4

Thankyou

I just want to create data bases

No formulas no functions

Without getting "functions isn't valid" or my entries being replaced with numbers or letters when I try to change input

Answer 5

Hi TiffanyBlue10!

I'm Jen, and I'd be happy to help you out with this issue.

Could you please explain further what functions you want to be removed? Thanks in advance.

Kind Regards,

Jen :)