| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TEXT function question
Why is this OK: =TEXT(A8/1000,"#.00 K")
But this returns #VALUE!: =TEXT(A8/1000000,"#.00 M") (I know I can use =TEXT(A8/1000000,"#.00")&" M" ) It seems some letters are allowed as part of the format in TEXT while others are not. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Improve Excel Help Text - Make easier to Find Function Refs | Excel Worksheet Functions | |||
| CountIf Function Question | Excel Discussion (Misc queries) | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| text function | Excel Worksheet Functions | |||
| Excel IF function for text | Excel Worksheet Functions | |||
Threaded Mode
