| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format
Thank you!! This works beautifully as well!! :)
"JMay" wrote: =--LEFT(B2,4) Left() retutns a string - but the "--" converts it back to a number. HTH "frustratedwthis" wrote: This is probably an easy one...and I'm sorry :) No. BU # Amt. ? 21000 $15.00 I would like to format the no column to only bring over the first 4 numbers from the BU column... Is this possible? Thanks in advance!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Hybrid Mode
