Re: Reformatting numbers in cells
Tech-Archive recommends: Fix windows errors by optimizing your registry
=LEFT(C1,FIND("/",C1))&TEXT(--(MID(C1,FIND("/",C1)+1,99)),"#,##0")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Joanne" <Joanne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:486A62D5-829A-4FC8-B7EB-7496FB397C30@xxxxxxxxxxxxxxxx
We have a report which is printed without commas in the numbers but with a
preceding number and a slash. For example,
09/834602. The users would like the "834602" to read "834,602" but I
can't
figure out how to do this because of the presence of the 09/. I am VERY
new
to this. Thank you very much for your help.
.
Relevant Pages
- Re: date formulas
... The formula adjusts it to the preceding Monday in case it was ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ...
(microsoft.public.excel.misc) - Re: Selection.Cells vs Range reference - strange behaviour (using
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... parentheses to indicate the parameters to be passed. ... I have a series of subs for formatting text along the lines of ...
(microsoft.public.excel.programming) - Re: Help with SUMIF
... It worked because any non-zero value is TRUE, so for the odd columns *1 ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... "Bob Phillips" wrote: ...
(microsoft.public.excel.worksheet.functions) - Re: A bit more help needed on an =SUMPRODUCT if possible?
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Try posting the data with some cell character to show where they change, ... GD and a separate monthly readout for analysis purposes... ...
(microsoft.public.excel) - Re: Formula to get sum from one 31 sheets to a summary sheet.
... "Bob Phillips" wrote: ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... This is brand new to me, please forgive me if my related communication is ...
(microsoft.public.excel.misc) |
|
