Do you know if there is a way when keying in numbers using 10 key that you can set up a spread sheet to automatically insert the decimal point? Example I key 12345 and want it to enter as $123.45. I tried to format the sheet using 2 decimal points but it enters it as $12,345.00 vs. $123.45.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Cell Formatting Question
- Thread starter MrMeric
- Start date
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering... ![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status
Similar threads
- Locked
- Question