| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE
I understand the TEXT function, however when I format it as TEXT(F19,"0,0"),
I get 1,000, displayed correctly. Also 10 thru 999 displays correctly, but 1 displays as 01, 2 as 02. Can I suppress the zero in single digit numbers? Also, is it possible to bold and underline within a TEXT function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Result displays "FALSE" instead of "FAIL" | Excel Discussion (Misc queries) | |||
| IN EXCEL, TO CENTER & UNDERLINE A YEAR (ie: 2009), NOT "2,009"? | Excel Discussion (Misc queries) | |||
| excel displays "l" instead of "‚¬" symbol for Euro values | Excel Discussion (Misc queries) | |||
| ACCESS ="NO" BUT EXCEL DISPLAYS "0" | Excel Discussion (Misc queries) | |||
| "." on numeric keypad displays "," | Excel Discussion (Misc queries) | |||
Threaded Mode
