have numbers automatically fill in

still learning

Well-known Member
Joined
Jan 15, 2010
Messages
688
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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

still learning

Well-known Member
Joined
Jan 15, 2010
Messages
688
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,388
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,851
Messages
5,833,967
Members
430,249
Latest member
Muka

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