LEFT() versus --LEFT()

loesbrown

New Member
Joined
Nov 29, 2019
Messages
1
Office Version
365
Platform
Windows
Hello, I am using this formula --LEFT() instead of LEFT(), and I get different results, but I do not actually understand why. Can anybody explain what the -- does to the formula?
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
LEFT returns text. If the result of your LEFT formula looks like a number, then --LEFT() will convert it into an actual number, so for example LEFT("19JUN89",2) would return the text "19" and if you want the actual number 19 you'd use the -- (or you could use +0 at the end). For many functions in Excel, "19" and 19 are quite different.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,124
Messages
5,466,830
Members
406,501
Latest member
TheoDoc

This Week's Hot Topics

Top