ExcelBanter - textbox formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - textbox formatting (https://www.excelbanter.com/excel-discussion-misc-queries/102975-textbox-formatting.html)

jnf40

textbox formatting

is there a way to type in a fraction, such as 1 3/4, into a textbox on a
userform and keep that format rather than changing to 1.75 automatically?

raypayette

textbox formatting

Click Format, Cell, Fraction.

--
raypayette

------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=568007

All times are GMT +1. The time now is 02:48 PM.