Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Reformatting numbers in cells
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Reformatting numbers in cells
=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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformatting text in cells | Excel Worksheet Functions | |||
Auto - reformatting | Excel Discussion (Misc queries) | |||
Macro for reformatting cells | Excel Worksheet Functions | |||
Reformatting a column | Excel Discussion (Misc queries) | |||
Reformatting numbers | Excel Discussion (Misc queries) |