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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies