have numbers automatically fill in

still learning

Well-known Member
Joined
Jan 15, 2010
Messages
618
Office Version
  1. 365
Platform
  1. Windows
Hi, Happy New Year

Is there a way to have numbers automatically fill in when I type one or two numbers like when text is entered.

I'm still learning about macros so be kind :) :LOL:

mike
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

still learning

Well-known Member
Joined
Jan 15, 2010
Messages
618
Office Version
  1. 365
Platform
  1. Windows
Hi FDibbins

I'm making a spreadsheet to record dates and amounts
Most of the amounts will be the same. I was wondering if I start to enter an amount, excel would recognize it and finish the typing.
All amounts will be in column C
Most amounts will be 756.56
Once in a while i might enter a different amount but it wouldn't start will 75
If I start to type 75, the rest of the number comes up and I would hit enter

I'm compering it to when I type a word and if the word or part of the word is anywhere above in the column, excel finishes it for me

I mentioned that I'm not to good with macros. If that's what I have to do, I'll need to see it.


mike
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Perhaps have a cell somewhere where you enter that number, then give it a short named range (say aa), then where you want that value to be, just type in =aa
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,188
Office Version
  1. 2016
Platform
  1. Windows
Or use could be made of AutoCorrect whereby, for example, a75 is entered and is corrected to 756.56
 

Watch MrExcel Video

Forum statistics

Threads
1,123,383
Messages
5,601,318
Members
414,441
Latest member
KellyTheKid

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