=text

Hey, Fairly new to this so any help is appreciated. We use excel to run graphics on a OBS System for a money exchange company - issue being OBS only likes to use "text" formatting, not number, currency or even general. We show a lot of currency on the the screen that we copy from various...

Hi all, within a macro I am trying to apply an IF statement to a cell. Basically IF the current date = Monday then return the date from 3 days prior, else display date 1 day prior. eg: current date = 4th July 2016(ie a Monday) = result 1st July 2016 (ie previous Friday date) current date =...

I get =TEXT(B3,"000-000-0000") to work and format the cell the way i want. I also get =IF(ISBLANK(B4),"none",B4) to work the way i want. But how would i format the cell in the above format if it contains a value, then if it is blank to display "none". TIA Ed

This must be simple but it eludes me. I have a set of values 0 to 99 that I need to append as a two character string to an existing string. I can go through an "if" routine that checks and then functions but it seems like "too much cure for too little sickness". Isn't there some easy one...