Created a Table with Lists Now I Need to Change the Value Column from Number to Currency and Don't Know How

Old Momma

New Member
Joined
Jun 6, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I want to create a basic dashboard, however, have been playing around with tutorials and have confused myself.

I have 7,000+ line items of historical data dating back to 2015. I created a table using the data with 5 columns > Year, Category, Subcategory, Month and Value.
1. Year > select any year - 2015 to current
2. Category > select > Activity, Program, Financial or Users
If ACTIVITY > select from various education types​
If PROGRAM > select from Active Users, Credits Awarded, Evaluations or System Users​
If FINANCIAL > select from Commercial Support, Exhibitors or Registrations​
if USERS > select from Division, Facility or State​
3. Subcategory > dependent on Category selected.
4. Month > select Month
5. Value > for historical data I currently have manually added the numbers but they should be based on the Source Data but the numbers aren't changing.

Because I can't get the VALUE correct I've had to create 6 rows to show each value for 2015.

What did I do wrong?
 

Attachments

  • Dashboard Sunday 1 Table.PNG
    Dashboard Sunday 1 Table.PNG
    59.9 KB · Views: 11

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,147,517
Messages
5,741,631
Members
423,674
Latest member
Charles2dodo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top