Home

Left / Right Function

inwuwetrust_2012
Occasional Visitor

Hey all,

 

I do a daily download from bloomberg that leaves me with information such as "13M" or "-13M", etc.. when i only want the "13".. i use the left/right function to drop the letter, but i can't get excel to view the "13" as a number.  For example, if i have a "-13M", it will drop the "M",  and leave me with a "-13", but when i use the "if" function to determine if the "-13" is greater or less than zero, it always shows as a positive number.  how do i fix this?

1 Reply
Wrap the number stored as text with VALUE to convert it to number, like this:
=VALUE(text)
Related Conversations
Which formula to use
Ramon Haagen in Excel on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Combining IF and INDEX functions
Hans van Deursen in Windows PowerShell on
2 Replies
Finding the data and to color code it
NishantSalunkhe in Excel on
3 Replies
=Function() returning incorrect date in some cells
tom_gowen in Microsoft Teams on
1 Replies