FORMAT vs TEXT

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Does anyone else feel the pain of this? PowerPivot and VBA both use the FORMAT function, but Excel uses TEXT. Maybe it's just me, but I find myself typing FORMAT in the worksheet grid frequently. Anyone else think that MS should be building a FORMAT function in Excel 16?
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
I'd give someone else's left arm for a native concatenate function that accepts a range or an array as an argument.
 
Top