Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,074
- Office Version
- 2019
- Platform
- Windows
I'm having a difficult time understanding why my textbox will not display the last digit.
Cell Value = $1.23932
Cell format = NumberFormat = "_($* #,##0.00000_);_($* (#,##0.00000);_($* ""-""?????_);_(@_)"
Textbox format = Format(Range("H" & ActiveCell.Row), "0.00000")
the number is displayed as 1.23930.
Why is the number the number 2 not showing up????
Cell Value = $1.23932
Cell format = NumberFormat = "_($* #,##0.00000_);_($* (#,##0.00000);_($* ""-""?????_);_(@_)"
Textbox format = Format(Range("H" & ActiveCell.Row), "0.00000")
the number is displayed as 1.23930.
Why is the number the number 2 not showing up????